HI All
I am trying to setup an alert for when our firewalls loose connection to both Active/standby panoramas
I have got it working in swql with:
SELECT Nodes.Uri, Nodes.DisplayName, P.CurrentValue as [Primary Pano], S.CurrentValue as [Secondary Pano] FROM Orion.Nodes AS Nodes left Join ( Select NodeID, CurrentValue from Orion.NPM.CustomPollerAssignment WHERE (CustomPollerOid = '1.3.6.1.4.1.25461.2.1.2.4.1') ) P on P.NodeID = Nodes.NodeID left Join ( Select NodeID, CurrentValue from Orion.NPM.CustomPollerAssignment WHERE (CustomPollerOid = '1.3.6.1.4.1.25461.2.1.2.4.2') ) S on S.NodeID = Nodes.NodeID WHERE P.CurrentValue != 'Connected' AND S.CurrentValue != 'Connected'
But when creating the custom swql query i am unable to adjust the Select section:
SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes
Could anybody assist
Thanks