Percentages over 100%

[mouchyn]

Since Zabbix doesn't let me export the displayed data from the "Availability Report," I'm tracking system availability for leadership reports using the following item on each host:

100*(avg(//zabbix[host,active_agent,available],30d))

In Zabbix 6.4, that works perfectly. In 7.0, most of the hosts are reporting greater than 100% availability. The same exact hosts in 6.4 and 7.0 do not show the same data for this item. Does anyone have an idea why that might be? Or does anyone know how to export or aggregate the data from the built-in Availability Report?

Thanks in advance.

[Brambo]

Not solving your direct issue, but for reporting of availability which is usually linked to SLA's the SLA report would be a much better route to explore.
A SLA report can be shown on a dashboard but also this dashboard could then be used in scheduled reports to mail it every X period.
You need the webservice component for that but once setup you will be happy.

BTW setting SLA services up the way you want can be a bit tricky but it's very flexible and is much better than only show if a problem was active or not.

[mouchyn]

I figured out what it is.

On zabbix 6.4, we were doing passive checks, so the agent availability values could only be 0 or 1. Averaging those numbers gives me what I want for each host.

When we moved to 7.0, we switched to active checks with encryption. The possible values for agent availability for active checks are 0, 1, or 2 with 2 being "not available." The longer a system is offline, the higher the average goes!

This item formula should be good enough for us:

200-(100*(avg(//zabbix[host,active_agent,available],30d)))