1 Reply Latest reply on Feb 21, 2013 2:39 PM by RichardLetts

    Is there any equivalent NPM variable available for ObjectType property in Orion.AlertStatus entity ?

    gupta

      Hi,

      Is there any equivalent NPM variable available for ObjectType property in Orion.AlertStatus entity.

      I am querying ObjectType property from Orion.AlertStatus entity. It is giving values like Node,Volume,Group etc.

      But i want to know any equivalent NPM variable for ObjectType property.

        • Re: Is there any equivalent NPM variable available for ObjectType property in Orion.AlertStatus entity ?
          RichardLetts

          What are you trying to do? You need to be a little more specific on what you are trying to achieve not the path you are following.

           

          In SQL studio this works:

          SELECT AlertDefID, ActiveObject, ObjectType, State, WorkingState, ObjectName, AlertMessage, TriggerTimeStamp, TriggerTimeOffset, TriggerCount, ResetTimeStamp, Acknowledged, AcknowledgedBy, AcknowledgedTime, LastUpdate, AlertNotes, Notes

          FROM Orion.AlertStatus

           

          This allows you associate the ActiveObject [a number] with the correct table. So if ObjectType='Node' then Orion.AlertStatus.ActiveObject=Orion.Nodes.Nodeid

          i.e.

          SELECT AlertDefID, ActiveObject, ObjectType, State, WorkingState, ObjectName, AlertMessage, TriggerTimeStamp, TriggerTimeOffset, TriggerCount, ResetTimeStamp, Acknowledged, AcknowledgedBy, AcknowledgedTime, LastUpdate, AlertNotes, Notes

          FROM Orion.AlertStatus A

          inner Join Orion.Nodes N

                  ON N.NodeID=A.ActiveObject

          WHERE A.ObjectType='Node'