Summarize values of items

[piet200]

I have some itemes which contain numeric values, now I would like to calculate the totals of these items.
I want a few totals like: day, week month
and present them in a screen.

What do I need to do to get this done ?

[Bill Wang]

1. use a script to get data from mysql directly and calculate them, this is what I am doing.

2. zabbix has calculate item type, which you can define the item with arithmetic expression, more details are on the online manual page.

[piet200]

Thanks for your information.

I was afraid that I would need a script to get the information directly from the database.

I am a bit disappointed that is isn't integrated in the web interface, that's what I would expect.

[Davidus]

My suggestion would be zabbix "Bar reports"
bit information on Bar reports can be found here

[Bill Wang]

Thanks for your information.

I was afraid that I would need a script to get the information directly from the database.

I am a bit disappointed that is isn't integrated in the web interface, that's what I would expect.

For me, it's not a big problem, just query the data that are already stored in zabbix server database, then define a user parameter, and give the result to zabbix server, then add a new item with this user parameter key, then you can see the final data on web page.

I have several clusters to monitor, zabbix can give me the network throughput of every single server, but I want to know the total throughput of a cluster, so I write a script to query the data network throughput of every server in mysql, then calculate the final result.

The script is attached, hope you can get help with it.

[piet200]

thanks for your information.

I'll have a look at your script and find out if it's usefull for me.

there is one difference with my situation, I have all the information I need written to the same key so I would expect an easy way to show me the total of the values written to this key for a period in time.

I would like to have a simple table which shows the total values of one specific key on a per hour, day, week, month base

so the column header says "totals item1"
and the rows say: last hour, today, this week, this month, this year

would I need a script for this too ?
If so, has someone got a script to do this already ?

[piet200]

no one ?

If I look at the history graph of a specific item which holds numeric values I can get back in time for 1 hour, 2 hours, 1day, 1 week, 1 month, etc.

Although I would like to show the totals of 1 day,week ,month in a table, the data is already there, so I would just have to change a formula to get this information from a specific key I guess ?