Zabbix Calculated Items

With calculated items, you can create calculations on the basis of other items.
Thus, calculated items are a way of creating virtual data sources. The values will be periodically calculated based on an arithmetical expression. All calculations are done by the Zabbix server - nothing related to calculated items is performed on Zabbix agents or proxies.
www.zabbix.com/documentation/...
☕ In case if you want to support this content with coffee:
☕ www.buymeacoffee.com/dmitryla...
👋 SOCIAL MEDIA
📹 TWITTER - @RealDeimons
🔔 INSTAGRAM - / dmitrylambert
📫 Sign Up For Newsletter And Don't Miss Out on Anything
📫 tinyurl.com/4sz2ewfb

[@DmitryLambert]

► Grab your Monitoring Love Merchandise - teespring.com/stores/monitoring-it

[@mustaphaaissat8582]

Many thanks. I would like to suggest a topic : "Event Correlation"

[@briancoverstone4042]

When defining your formula I would recommend leaving the quotes in and escaping the inner quotes.
You can escape a single quote by placing a backslash before it. Such as last(fred["abc"]) --> last("fred[\"abc\"]")
Note the outside quotes are not escaped, but the inside quotes are escaped so they become part of what is in the quotes instead of ending the quoted string.

[@amitarora1179]

Hey Dmitry, this seems to be only for numeric data. Is there any functionality available which can help to club data from 2 items with text as output. I have an SNMP trap message which i am trying to break. I am able to successfully fetch error message and hostname in 2 respective items using regex. But unable to merge them. Any suggestions

[@ap_in]

Dear Dmitry, thanks for the videos your helping with. I am new to zabbix, I understood caculated items, I have a doubt on the example you worked with, when the zabbix agent items are preprocessed with custom multiplier 8, to convert bps to Bps, the stored value in database should be in Bps and it should be returning the same to the calculated item for calculation. So I think the units in the calculated item should be in "Bps" not "bps". Please correct me. Thanks

[@freddyfreire8936]

Hi there... Is possible to create and test a formula able to convert from Celsius to Farenheit, using the available data from an APC UPS probe?
Can you help me, please?

[@OthmanAlikhan]

Thanks for the video =)

[@DmitryLambert]

My pleasure!

[@mateeshbhave7988]

Hi Dmitry, which microphone/headphones do you use for recording videos? Your voice in the video is very clear.

[@DmitryLambert]

Razer pro 7.1

[@barabucho]

How to quick debugging expression (formulas) of calculate item?

[@Ferraresse]

Hello Dmitry and thank you for your videos and tutorials.
I have one question, my item is declared to get a value from a file in this way with a regexp: vfs.file.regexp[/var/log/IoT/log,"(P-ZZ-1).*:.\s([0-9]*)?",,,,\2]
but when i put the expression in a calculated item I get the error that it cannot evaluate the function because Template:vfs.file.regexp[bla, bla, bla... doesn't exit. Is there any way to use file regexp in calculated items?
Regards.

[@TechNetworking]

We have 6.0 zabbix but I want to create only up ports graphs how do that

[@multazimdeshmukh8408]

Hi Dmitry, I am trying to sum all the items discovered through an lld. How would that be possible? All the items have numerical value and have key format : Size[{#VENDOR}]

[@ioanniskapnisakis6621]

Thanks for video Dmitry.
So in a calculated item instead of a trigger expression (like in the Zabbix agent) I simple define the expression in formula field?
I want to create a calculated item which will set a trigger when the free disk space of a host, has been decreased more than 5G within the last hour.
I am thinking something like :
last("{host_name:vfs.fs.size[{/home},free]}",0,3600) < 0 and abs(last("{host_name:vfs.fs.size[{/home},free]}",0,3600)) > 5G
How can I define the absolute value on Zabbix? Perhaps with the abschange function??
Could you give me an example for abschange function?
Any help/hint is really appreciated
Thanks in advance

[@DmitryLambert]

No, you can't use trigger expressions in formula

[@cenubit]

Hi! I have a value from remote host .pfx certificate file = YYYYMMDD How is possible calculate from that the nummber of days diffenet ftom current date?

[@nicolasgmarseille3631]

how can I use calculated item in my template ? how to refer to a generic hostname ? the """{HOST.NAME}:my_item wildcard does not work

[@FahmiPersada]

how to calculate total bandwidth usage? example total for monthly usage.

[@chandandutta3319]

Have you got the way

[@manologitech]

Great

[@DmitryLambert]

Books About Zabbix
Amazon COM
► Zabbix 4 Network Monitoring 3rd Edition amzn.to/2Ra7XDE
► Zabbix Network Monitoring 2nd Edition amzn.to/2DQLWqI
Amazon UK
► Zabbix 4 Network Monitoring amzn.to/2G7BCey
► Mastering Zabbix - Second Edition amzn.to/306Ru86
Amazon DE
► Zabbix 4 Network Monitoring amzn.to/2FYg3NU
► Zabbix Cookbook amzn.to/3iXuqQK