Calculated Items

Video Lecture

Calculated Items Calculated Items

Description

I create 3 calculated items and a graph from them in this lecture.

But first, we need to create a UserParameter as our base item that we will be doing calculations on.

Example Base Item

Add the UserParameter to the Zabbix Agent config on the Zabbix server.

1
UserParameter=mysql.questions, mysqladmin -uzabbix -ppassword status | cut -f4 -d":" | cut -f1 -d"S"
Key Value
Name MySQL Questions Running Total
Type Zabbix Agent
Key mysql.questions
Type numeric

Example Calculated Item 1

Key Value
Name Changes MySql Questions
Type Calculated
Key mysqlchanges
Formula change(mysql.questions)

Example Calculated Item 2

Key Value
Name Average of Changes of MySql Questions
Type Calculated
Key avgmysqlchanges
Formula avg(mysqlchanges,#5)

Example Calculated Item 3

Key Value
Name Forecast of Changes of MySql Questions
Type Calculated
Key forecastmysqlchanges
Formula forecast(mysqlchanges,1h,,10m,exponential)

Other Resources

Calculated Items

https://www.zabbix.com/documentation/current/manual/config/items/itemtypes/calculated

Trigger Functions

https://www.zabbix.com/documentation/current/manual/appendix/triggers/functions