how to collect all Avg data to excle file

[Premchand Gupta]

Hi

I need reports for CPU, Memory usage of all the servers for last 30 days

I went through the zabbix DB but didn’t find any table which has the required data available

Please let me know if you have any implementation which will help me to get the above reports or at least DB table names or DB query which will help to achieve the same


Thxs
Premchand Gupta

[exkg]

You can use "Aggregated checks":

Aggregate checks do not require any agent running on a host being monitored.
ZABBIX server collects aggregate information by doing direct database queries.
Syntax of aggregate item's key:

groupfunc[“Host group”,”Item key”,”item func”,”parameter”]

I think its can help you. In 1.8 version is posible create some reports with bar graphs.



[]s,
Luciano