Agent availability trend data

[emurdoch]

Hi,

I'm trying to access agent availability data in order to build a dashboard to present KPI data on hosts connected to Zabbix.

Previously I was accessing "Agent availability", "Zabbix agent availability", and "SNMP agent availability trend data through the "trend" api endpoint (which I was accessing via a Python script.

I am now trying to access this information directly through the mySQL database, however within this the agent availability trend data is not available.

Does anyone know whether this would be stored within another table or how I can access this via the database?

Many thanks in advance!

Ewan

[emurdoch]

I've managed to find the data I was looking for in the trend_uint table

[cyber]

You are leaving out your query....
I assure you all the data is there, otherwise API would also fail to show you something..

[emurdoch]

I'm pulling the tables from the mySQL database directly into PowerBI and querying them from there.

As an example of what I'm looking for I have the following SQL ,query:

SELECT *
FROM trends
JOIN items ON trends.itemid = items.itemid
WHERE items.name = "Zabbix agent availability"

I am able to access, for example, "CPU utilization", but can't get anything for agent availabiltiy.

Thank you for your help, I'll keep looking through the documentation to see where this could be stored

[emurdoch]

I've managed to find the data I was looking for in the trend_uint table