Zabbix Report Triggers Top 100

[linax101]

Is there anyway to get this report to exclude hosts that have a maintenance window ?

[linax101]

If that is not possible can someone provide a query that I can run against postgresql zabbix database to obtain the same thing ?

[troffasky]

Did you ever get an answer to this?

[troffasky]

Well, anyway,: https://support.zabbix.com/browse/ZBXNEXT-4638

[ingus.vilnis]

I assume there might be a problem to do this now because Triggers top 100 page is generated form event status changes but in the events table there is no field to indicate whether that event was generated while host is in maintenance mode or not. Anyways looks like a valid feature request.

[NgRox]

Here is the SQL code that pulls this data over the 30 day period:

I hope it helps!

SELECT h.name, t.description, COUNT(e.eventid) 'count' FROM hosts h INNER JOIN items i ON h.hostid = i.hostid INNER JOIN functions f ON i.itemid = f.itemid INNER JOIN triggers t ON f.triggerid = t.triggerid INNER JOIN events e ON t.triggerid = e.objectid AND e.object = 0 AND e.source = 0 AND e.value = 1 AND e.clock > UNIX_TIMESTAMP() - 86400*30 WHERE h.status = 0 AND i.status = 0 AND t.status = 0 GROUP BY h.name, t.description ORDER BY count DESC LIMIT 100;