link between triggers table and hosts table

[alucard95]

Hello,

I need to extract some informations in zabbix database about triggers and hosts.
The problem is when I look at the trigger's table, I did not find any link with the host and I'm not able to associate triggers and host.
For examle, in the item's table, I found the fields named "hostid" which allow to identified the host.

Is anobody knows how to link triggers table and hosts table?

[trikke]

Hi,

as far as I know the link between triggers and items is done thru the functions Table, so something in the line of ( out of me head, try it out!!)

select * from triggers t,items i,functions f where i.itemid=f.itemid and f.triggerid=t.triggerid

Greets
Patrick

[alucard95]

Hi,

I found the same thing this night .
In the functions table, there are itemid and triggerid. Now, I know all zabbix database