Zabbix SQL queries collection

active-triggers-count.sql

select count(*) FROM (select distinct h.hostid, h.host, t.description from triggers t 
join functions f on f.triggerid = t.triggerid 
join items i on i.itemid = f.itemid 
join hosts h on h.hostid = i.hostid
join hosts_groups hg on h.hostid = hg.hostid
join hstgrp hg2 on hg2.groupid = hg.groupid

where 
-- value=1 - trigger is in problem state
t.value = 1 and
-- t.status=0 - trigger is enabled
t.status = 0 and
-- h.status=0 - host is enabled
h.status = 0

-- host name filter. Can be changed to hostid instead
and h.host = "somehost"

-- host group name filter
-- and hg2.name = "somegroupname"

-- optional severity filter where 0 - not classified, 1 - normal, 2 - warning, 3 - average, 4 - high,  5 - disaster
-- and t.priority > 3

-- optional extra filter on trigger description...
-- and t.description like '%Trigger name'
-- 
) as subq

active-triggers-list.sql

select distinct h.hostid, h.host, t.description from triggers t 
join functions f on f.triggerid = t.triggerid 
join items i on i.itemid = f.itemid 
join hosts h on h.hostid = i.hostid
join hosts_groups hg on h.hostid = hg.hostid
join hstgrp hg2 on hg2.groupid = hg.groupid

where 
-- value=1 - trigger is in problem state
t.value = 1 and
-- t.status=0 - trigger is enabled
t.status = 0 and
-- h.status=0 - host is enabled
h.status = 0

-- host name filter. Can be changed to hostid instead
and h.host = "somehost"

-- host group name filter
-- and hg2.name = "somegroupname"

-- optional severity filter where 0 - not classified, 1 - normal, 2 - warning, 3 - average, 4 - high,  5 - disaster
-- and t.priority > 3

-- optional extra filter on trigger description...
-- and t.description like '%Trigger name'
-- 

References:
https://zabbix.org/wiki/Docs/DB_schema/trunk/
https://www.zabbix.com/documentation/5.0/manual/api