This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Need to adjust the alerting on section when setting up swql alert

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

Parents Reply Children
No Data