Zabbix Montly Reporting (min, max avg)

[DarkFAF]

Hello everyone! it is possible to generate monthly reports for CPU Utilization, disk space utilizations (Filesystems), memory? I'm trying to use JasperReports via API, but I see that trend.get returns poor information.



{ "jsonrpc": "2.0", "method": "trend.get", "params": { "output": [ "itemid", "clock", "num", "value_min", "value_avg", "value_max", ]

I need to extract montly informacion for average, min and max.

example:

| Host | Filesystem | Max | Min | Averge |
------------------------------------------------------------------------------------
| server01 | /home | 3.3 GB | 2.0 GB | 2.5 GB |
| server02 | /home | 4 GB | 1.0 GB | 3.2 GB |
| server01 | /etc | 300 MB |100 MB | 270.MB |
--------------------------------------------------------------------------------------


Is it possible to do this with another tool? kibana elasticsearch, SQL etc, Help please!

regards!

[mikk]

You can create a calculated item with trendavg function like trendavg(//vm.memory.util,1M:now/M). this this will give you the avg value of previous month.
simillarly you can do it for other components as well.

and setup a api which will fetch the item with the key you setup for the calcualted iteam and collect the lastvlaue output for your reporting.
it's not the best, but somewhat managable and practical to get the appropriate data.

It worked for me (i'm using 6.4 azbbix). hope this will work for you as well.