Zabbix每天流量统计脚本

hhnf333

traffic.sh　　
#
!/bin/bash　　
mysql
-hlocalhost -uroot -p33e9.com -B zabbix -e "select TIMESTAMPADD(day,-1,curdate()), switchname, traffic_name, FORMAT(max(bps/1000000),2) as Mbps from (select gi.itemid, h.name　　
as switchname, g.name as traffic_name, s.name as traffic_inout, max(u.value) as bps, from_unixtime(u.clock) as traffic_time from graphs g  join graphs_items gi  on g.graphid = gi.gr
　　
aphid join items s on gi.itemid = s.itemid join hosts h on h.hostid = s.hostid  join history_uint u  on s.itemid = u.itemid where g.graphid in (552,557,559,561,574,578,582,584,586,5
　　
88,590,636,639,641,554,553,566,569,571,580,654)  and u.clock > UNIX_TIMESTAMP(TIMESTAMPADD(day,-1,curdate()))  and u.clock < UNIX_TIMESTAMP(curdate())  group by gi.itemid) t  group
　　
by switchname, traffic_name into outfile '/var/lib/mysql-files/internet.csv' fields terminated by ','"