Custom SWQL Resource to show IPSLA Alerts on Node Details Page

Version 1

    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}