How to export the relationship between triggers-host to a text file

[Pablo]

Hello,

I need to join zabbix with another system who receive the alarms defined as a trigger in the "zabbix frontend".
I have thought about doing this, exporting the "true triggers" (in active state) to a text file and later reading this file from my system.

I need at least this information:
hostid-triggerid-triggerstate

I found the triggers table in zabbix database structure but I am not able to find th e relationship between triggers and hosts.
I thought in parser the expression field which contain the host in the frontend:
{<server>:<key>.<function>(<parameter>)}<operator><const>
but in the database can't see this expression.
Are there any relationship between hosts and triggers?

Thanks
Pablo

[Pablo]

I think that I can do it using the function table.

Thanks