Zabbix query - active triggers

[mvrk]

Hi,

I need to send an email periodicaly with the active triggers on my zabbix server, can someone help me with a query to retrieve the current active triggers from zabbix database, something like this:

host | trigger description | item_name | item_value

[igor]

Hi!
Such SQL query can look like:

select h.host, t.description, i.description, i.lastvalue
from hosts h, triggers t, items i
where triggerid in
(
select t.triggerid
from items i, hosts h, triggers t, functions f
where t.triggerid = f.triggerid and f.itemid = i.itemid and i.hostid = h.hostid and t.status=1
)