custom query for fetching active alerts

 I am trying to query the below parameters (Active Alarms , relevant Node details , its Severity and Region etc.) ...From the documentation active alerts can be fetched from this details 

[Orion.AlertActive ] 

in the above table , i am not able to query relevant node details , severity ,, can some one help me which this creating custom query ...to fetch these properties [Active alerts , respective node id , alert severity , and region ]

Parents
  • I usually use the Event Table instead of the Alert Table. EventType 5000 is an Alert and 5001 is the Reset. The Message field contains the event message. That should get you started. 

    SELECT TOP 1000 EventID, EventTime, NetworkNode, NetObjectID, NetObjectValue, EngineID, EventType, Message, Acknowledged, NetObjectType, TimeStamp, DisplayName, Description, InstanceType, Uri, InstanceSiteId

    FROM Orion.Events
    Where EventType LIKE '%5000%' OR EventType LIKE '%5001%'
Reply
  • I usually use the Event Table instead of the Alert Table. EventType 5000 is an Alert and 5001 is the Reset. The Message field contains the event message. That should get you started. 

    SELECT TOP 1000 EventID, EventTime, NetworkNode, NetObjectID, NetObjectValue, EngineID, EventType, Message, Acknowledged, NetObjectType, TimeStamp, DisplayName, Description, InstanceType, Uri, InstanceSiteId

    FROM Orion.Events
    Where EventType LIKE '%5000%' OR EventType LIKE '%5001%'
Children