Looking for an hourly email for unacknowledged alerts.

jasonpurvis

Basically we are starting to set SLAs for acknowledging alerts for the NOC and I am looking to setup escalation across the board for management. Looking for a list of Unacknowledged Alerts without setting up multiple escalation steps for each alert profile. Any Suggestions?

jasonpurvis

I believe i answered my own question, I have come up with this.

"SELECT Distinct

AlertActive.AlertActiveID, AlertObjects.AlertObjectID, AlertConfigurations.Name, AlertConfigurations.Severity, AlertConfigurations.ObjectType,

AlertObjects.EntityUri, AlertObjects.EntityType, AlertObjects.EntityCaption,

ToLocal(AlertActive.TriggeredDateTime) AS TriggeredDateTime, AlertObjects.LastTriggeredDateTime, AlertActive.TriggeredMessage AS Message,

AlertActive.AcknowledgedDateTime, AlertActive.Acknowledged AS Acknowledged, AlertActive.AcknowledgedBy, AlertActive.AcknowledgedNote

FROM Orion.AlertObjects (nolock=true) AlertObjects

INNER JOIN Orion.AlertActive (nolock=true) AlertActive ON AlertObjects.AlertObjectID=AlertActive.AlertObjectID

INNER JOIN Orion.AlertConfigurations (nolock=true) AlertConfigurations ON AlertConfigurations.AlertID=AlertObjects.AlertID

Where Acknowledged IS NULL

and Severity = '2'

Order By AlertConfigurations.Name, AlertObjects.EntityCaption"

Hope this helps someone else,

Jason