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.

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'