Hi there
I am writing a query to link to my 24 Hour outage report. So far, I can get my list of nodes that were down and also the total length of time in minutes they were down.
This question relates to the Advanced Alerts and does the database record past alerts as opposed active alerts?
I am using the following to get the information before attempting to JOIN to my outage report.
The following simple output will give the required information
SELECT
AlertStatus.ObjectName AS ObjectName, AlertStatus.TriggerTimeStamp AS EventStart, AlertStatus.AcknowledgedTime AS AcknowledgedTime, AlertStatus.AcknowledgedBy
FROM
AlertStatus
Is there history of Active Alerts?
Thanks
Ken