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
  • For the alert trigger you won't need to return the Primary or Secondary Pano connected values, just to know that they are not connected will be enough. 
    You can then pull the Primary or Secondary Pano connected values into the alert subject or message, using the "Define SQL/SWQL Variable (Advanced)" option.

  • Hi yaquaholic

    Thanks for the reply

    I should have mentioned I am a network engineer and sql is not my thing , it took me forever to get alert working in swql.

    So not sure what you mean by pull values into alert.

Reply Children