统计

<!--应用管理-应用服务流量统计-->
<select id="selectAppServerStatByPage" parameterType="java.util.Map" resultType="cn.piesat.operationsupport.entity.vo.AppManagerStatVo">
  select * from (SELECT t2.APPLICAT appName,count(1) pv,sum(t2.SEND_TRAFFIC) sendTraffic,sum(t2.RECEIVE_TRAFFIC) receiveTraffic,
  sum(t2.DATA_PACKET) dataPacket,sum(t2.TRAFFIC) traffic FROM support_resource_appserver t1,"support_netraffic" t2 WHERE t1."IP_ADD"="DEST_IP" AND T2.APPLICAT IS NOT NULL GROUP BY t2.APPLICAT) appStat
  

<!--应用管理-其他流量统计-->
<select id="selectOtherStatByPage" parameterType="java.util.Map" resultType="cn.piesat.operationsupport.entity.vo.AppManagerStatVo">
  select * from (SELECT t2.APPLICAT appName,count(1) pv,sum(t2.SEND_TRAFFIC) sendTraffic,sum(t2.RECEIVE_TRAFFIC) receiveTraffic,
  sum(t2.DATA_PACKET) dataPacket,sum(t2.TRAFFIC) traffic FROM support_resource_otherforhttp t1,"support_netraffic" t2 WHERE t1."URL"=t2."DEST_IP" AND T2.APPLICAT IS NOT NULL GROUP BY t2.APPLICAT) appStat