Custom SWQL Resource to show IPSLA Alerts on Node Details Page

mark.d​

Add a Custom Query Resource to a node details view and use this query to show only IPSLA Alerts

SELECT

h.AlertObjects.AlertConfigurations.Name AS [AlertName],

h.AlertObjects.AlertConfigurations.Description,

h.AlertObjects.Node.NodeID,

h.Message,

h.TimeStamp,

('/Orion/NetPerfMon/ActiveAlertDetails.aspx?netobject=AAT:' + ToString(h.AlertObjects.AlertObjectID)) AS [_LinkFor_AlertName]

FROM Orion.AlertHistory h

WHERE

1. h.AlertObjects.RealEntityType='Orion.IpSla.Operations'

AND h.EventType =0

AND h.AlertObjects.Node.NodeID=${NodeID}