Link icinga_statehistory to Notifications and Acknowledgements

(Bw00s) #1

Hi all,

Is there any way to link a icinga_statehistory change I.e Down/Warning/Critical to a icinga_notifications and icinga_acknowledgements entry in the IDO.

Ultimately what I’m trying to do is build a report showing Unacknowledged Alerts with proof that a Notification was sent. I’ve searched but cannot find a relationship the reliably links these tables. I could join using the state_time and object_id link but that will be very slow as the notification may not be sent at the same instant the state changed and the the alert might also not be acknowledged.

Any ideas?