This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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}

Parents
  • This fails for me. Are you missing the part of the select query to account for NodeID? Because that's what I'm seeing: "cannot resolve NodeID". Or, are you meaning to use RelatedNodeID?

    I had to delete the two lines at the top and bottom referencing NodeID to make this work.

Reply
  • This fails for me. Are you missing the part of the select query to account for NodeID? Because that's what I'm seeing: "cannot resolve NodeID". Or, are you meaning to use RelatedNodeID?

    I had to delete the two lines at the top and bottom referencing NodeID to make this work.

Children
No Data