Zabbix每天流量统计脚本
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 gjoin graphs_items gion g.graphid = gi.gr
aphid join items s on gi.itemid = s.itemid join hosts h on h.hostid = s.hostidjoin history_uint uon 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) tgroup
by switchname, traffic_name into outfile '/var/lib/mysql-files/internet.csv' fields terminated by ','"
页:
[1]