Sidebar
manual:config:items:itemtypes:aggregate
Table of Contents
12 Aggregate checks
Overview
In aggregate checks Zabbix server collects aggregate information from items by doing direct database queries.
Aggregate checks do not require any agent running on the host being monitored.
Syntax
The syntax of the aggregate item key is:
groupfunc["host group","item key",itemfunc,timeperiod]
Supported group functions (groupfunc) are:
| Group function | Description |
|---|---|
| grpavg | Average value |
| grpmax | Maximum value |
| grpmin | Minimum value |
| grpsum | Sum of values |
Multiple host groups may be included by inserting a comma-delimited array. Specifying a parent host group will include the parent group and all nested host groups with their items.
All items that are referenced from the aggregate item key must exist and be collecting data. Only enabled items on enabled hosts are included in the calculations.
The key of the aggregate item must be updated manually, if the item key of a referenced item is changed.
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 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).
An amount of values (prefixed with #) is not supported in the timeperiod.
Timeperiod is ignored by the server if the third parameter (item function) is last and can thus be omitted:
groupfunc["host group","item key",last]
If the aggregate results in a float value it will be trimmed to an integer if the aggregated item type of information is Numeric (unsigned).
An aggregate item may become unsupported if:
- none of the referenced items is found (which may happen if the item key is incorrect, none of the items exist or all included groups are incorrect)
- no data to calculate a function
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]
Example 2
Average processor load of host group 'MySQL Servers'.
grpavg["MySQL Servers","system.cpu.load[,avg1]",last]
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]