Modern Dashboard custom query help

Question

on this query i want to add node custom property = ATM Branch

SELECT TOP 10 n.Node.Caption AS Node_Caption,n.Caption,n.OperStatus FROM Orion.NPM.Interfaces n  WHERE (OperStatus = 2)

sreenathmp · Answer

You can try this

SELECT TOP 10 n.Node.Caption AS Node_Caption,n.Caption,n.OperStatus
FROM Orion.NPM.Interfaces n

WHERE (OperStatus = 2) and n.node.CustomProperties._Network_Device= 'True'

Replace <_Network_Device= 'True'> with your custom property and value.

MathieuJM · Answer

hello,

You can try

WHERE n.node.customproperties.yourpropertyname = 'ATM Branch'