I've setup a custom property that contains the parent node (upstream switch or router). How can I create an alert that takes this into account.
In other words, if parent node is down suppress this alert.
Modified from
If you manually put in the SQL trigger query in the database:
Select A.NodeId AS NetobjectID, A.Caption AS Name
From Nodes A, Nodes U
Where
(
(A.Status = '2') AND
(A.ParentNode = U.ParentNode) AND
(U.Status = '1')
)
