Hello everybody, I'm doing a KPI with data from Zabbix and the report would basically the Availability report but in stacked bar graphs showing the rate UP and DOWN buttons for each application or server.
Already I have triggers, but I can not able to model the query.
With the following query I could see the right trigger and the host, but she would not return the value, right trigger on the table that the 'value' field is empty, then this query would not be right, and I got it from reports2. php.
I believe that lack any algorithm that must pull these values and generate the percentage of TRUE, FALSE, and UNKNOWN.
So if someone can help me with this algorithm and the query or if you have any alternative to do this KPI, why it is urgent. blzz thanks you guys
Already I have triggers, but I can not able to model the query.
With the following query I could see the right trigger and the host, but she would not return the value, right trigger on the table that the 'value' field is empty, then this query would not be right, and I got it from reports2. php.
Code:
SELECT DISTINCT h.hostid,h.host,t.triggerid,t.expression,t.description,t.value
FROM triggers t, hosts h,items i, functions f, hosts_templates ht
WHERE h.status=0
AND h.hostid = 10059
AND i.hostid=h.hostid
AND i.status=0
AND f.itemid=i.itemid
AND t.triggerid=f.triggerid
AND t.status=0
AND ht.hostid=h.hostid AND t.templateid=13723
ORDER BY h.host, t.description
So if someone can help me with this algorithm and the query or if you have any alternative to do this KPI, why it is urgent. blzz thanks you guys