Add Acknowledge status to this critical alerts widget

the link didnt  save but the original post is here
Create an "Active Alerts" view based only on critical alerts - Alert Lab - The Orion Platform - THWACK (solarwinds.com)

wes.reneau, is this query the output you're looking for?

SELECT
o.AlertConfigurations.Name AS [ALERT NAME]
,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(o.AlertObjectID) AS [_LinkFor_ALERT NAME]
,o.EntityCaption AS [ALERT OBJECT]
,o.EntityDetailsURL AS [_LinkFor_ALERT OBJECT]
,o.RelatedNodeCaption AS [RELATED NODE]
,o.RelatedNodeDetailsURL AS [_LinkFor_RELATED NODE]
,ToLocal(o.AlertActive.TriggeredDateTime) AS [ALERT TRIGGER TIME]
,o.AlertActive.TriggeredMessage AS [ALERT MESSAGE]
,CASE
WHEN o.AlertConfigurations.Severity = 1 then 'Critical'
WHEN o.AlertConfigurations.Severity = 2 then 'Serious'
WHEN o.AlertConfigurations.Severity = 3 then 'Warning'
WHEN o.AlertConfigurations.Severity = 4 then 'Informational'
WHEN o.AlertConfigurations.Severity = 5 then 'Notice'
END AS [Severity]
, o.AlertActive.Acknowledged
, o.AlertActive.AcknowledgedBy
, o.AlertActive.AcknowledgedDateTime
, o.AlertActive.AcknowledgedNote
FROM Orion.AlertObjects o
WHERE o.AlertActive.TriggeredMessage <> ''
AND o.AlertConfigurations.Severity = 1
ORDER by o.AlertActive.TriggeredDateTime DESC

YES!  thanks for that!

How difficult would it be to have only unacknowledged alerts?  

wes.reneau, not difficult just add the following as part of the where condition

o.AlertActive.Acknowledged IS NOT NULL

-- Example
WHERE o.AlertActive.TriggeredMessage <> ''
AND o.AlertConfigurations.Severity = 1
AND o.AlertActive.Acknowledged IS NOT NULL

wes.reneau, I was testing this and noticed that between what I was expecting and what the output did not match up. Somewhere between when the query was first written and now the Severity numbers changed below is a version that is correct, I am on the latest versions for all modules

SELECT
o.AlertConfigurations.Name AS [ALERT NAME]
,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(o.AlertObjectID) AS [_LinkFor_ALERT NAME]
,o.EntityCaption AS [ALERT OBJECT]
,o.EntityDetailsURL AS [_LinkFor_ALERT OBJECT]
,o.RelatedNodeCaption AS [RELATED NODE]
,o.RelatedNodeDetailsURL AS [_LinkFor_RELATED NODE]
,ToLocal(o.AlertActive.TriggeredDateTime) AS [ALERT TRIGGER TIME]
,o.AlertActive.TriggeredMessage AS [ALERT MESSAGE]
,CASE
WHEN o.AlertConfigurations.Severity = 0 then 'Informational'
WHEN o.AlertConfigurations.Severity = 1 then 'Warning'
WHEN o.AlertConfigurations.Severity = 2 then 'Critical'
WHEN o.AlertConfigurations.Severity = 3 then 'Serious'
WHEN o.AlertConfigurations.Severity = 4 then 'Notice'
END AS [Severity]
, o.AlertActive.Acknowledged
, o.AlertActive.AcknowledgedBy
, o.AlertActive.AcknowledgedDateTime
, o.AlertActive.AcknowledgedNote
FROM Orion.AlertObjects o
WHERE o.AlertActive.TriggeredMessage <> ''
AND o.AlertConfigurations.Severity = 2
--Uncomment below for only alerts that have been acknowledged
--AND o.AlertActive.Acknowledged IS NOT NULL
ORDER by o.AlertActive.TriggeredDateTime DESC

fantastic!

THANKS!

fantastic!

THANKS!