Trigger / Alerts DB Quert

[Rafael.Marmo]

Hello,
I need to create a query that show all alerts generated for a given host or host group. The problem I am facing is that I dont know how the relationship between tables "Alerts, Triggers and Hosts" works.

May someone help me explaning how the DB Schema works for this tables?

Thanks and best regards,

[EnigmA-X]

I cannot show you the relations, but I can tell you that you might want to look into the 'actions' and 'events' tables.

If you're running on mysql, use 'describe <table>' to see what the fields of that table looks like.