Relation between ackowledges and hosts in DB

[Gigoudt]

Hi ,

im trying to do some reports directly in the database.

I want to do a query to establish what hosts with a problem has an active aknowledge and ones who dont. I cant figure out the relation in the database.

aknowledges is related with events by eventid.

I believe that threw the items could be posible to achieve to events table but cant find how !

relation is posible because it is done in the system tray in the dashboard .

thanks for any advice !!!!!

bye