12 Aggregate checks
12.1 Overview
In aggregate checks Zabbix server collects aggregate information by doing direct database queries.
Aggregate checks do not require any agent running on the host being monitored.
The syntax of the aggregate item key is:
groupfunc["Host group","Item key",itemfunc,timeperiod]
Multiple host groups may be used since Zabbix 1.8.2 by inserting a comma-delimited array.
Supported group functions (groupfunc) are:
| GROUP FUNCTION | DESCRIPTION |
|---|---|
| grpavg | Average value |
| grpmax | Maximum value |
| grpmin | Minimum value |
| grpsum | Sum of values |
Supported item functions (itemfunc) are:
| ITEM FUNCTION | DESCRIPTION |
|---|---|
| avg | Average value |
| count | Number of values |
| last | Last value |
| max | Maximum value |
| min | Minimum value |
| sum | Sum of values |
The last timeperiod parameter specifies a time period of latest collected values. Supported unit symbols can be used in this parameter for convenience, for example '5m' (minutes) instead of '300' (seconds) or '1d' (day) instead of '86400' (seconds).
timeperiod parameter is ignored by the server if the third parameter (item function) is last.
12.2 Usage examples
Examples of keys for aggregate checks:
Example 1
Total disk space of host group 'MySQL Servers'.
grpsum["MySQL Servers","vfs.fs.size[/,total]",last,0]
Example 2
Average processor load of host group 'MySQL Servers'.
grpavg["MySQL Servers","system.cpu.load[,avg1]",last,0]
Example 3
5-minute average of the number of queries per second for host group 'MySQL Servers'.
grpavg["MySQL Servers",mysql.qps,avg,5m]
Example 4
Average CPU load on all hosts in multiple host groups.
grpavg[["Servers A","Servers B","Servers C"],system.cpu.load,last,0]
Data source: Zabbix