Zabbix reporting question

[Kerrygeek]

Our manager just asked a reporting question but I don't see a way to directly produce a report from Zabbix like he wants. I am using SNMP to monitor bandwidth at each of our 23 locations on Cisco routers. Is there an easy way to find the highest bandwidth utilization on each of those 23 routers in the last month?

It looks like the reporting works from triggers, so I could probably do some kind of report for how often it hits a certain amount of traffic but I don't see a way to get a max for each router for the past month. Do you guys know of a way to get something like that? I know the data is in the mysql database somewhere but I don't have any good reporting tools to get that out. I'm thinking I'll have to look at a graph of each router and pick the highest and manually put it in a spreadsheet once a month but I'm open to suggestions for an easier way.

Thanks,
Kerry Miller
Victoria, TX

[Calimero]

If items (key name or SNMP oid) are the same across all routers, a single SQL query can fetch the highest value in the trends(_uint) table.

A simple shell/perl/php script could easily do some formating or simply output stuff as CSV (as everyone knows managers only know how to use Excel and Powerpoint).

I was wondering how hard it is to add new screens/pages to zabbix.
We have a script that collects how many (and soon what) system upgrades are pending. I'd like to write a zabbix page do display a list of machines with pending updates. Some kind of reporting...