Custom Poller alerting question

mjlee1979

Hi,

We have a custom poller on our Fortigate Firewalls showing the up/down status of the IPSEC tunnels. We have 2 tunnels over our Primary circuits with an MPLS and DIA VRF and 1 VPN over the secondary circuit. If the primary circuit goes down the 2 tunnels go down and traffic routes over the secondary however I'm trying to setup and alert to fire when both the tunnels over the primary circuit go down.

Is this achievable?

Thanks in advance.

mjlee1979

I've managed to get this working so for anyone else trying to achieve this here's my SQWL query I've used

Select
nodes.Caption as NODE,
cpson_dia_dc1.DisplayName as DC1_DIA_Name,
cpson_dia_dc1.Status as DC1_DIA_Status,
cpson_mpls_dc1.DisplayName as DC1_MPLS_Name,
cpson_mpls_dc1.Status as DC1_MPLS_Status

FROM Orion.Nodes as nodes

Inner JOIN Orion.NPM.CustomPollerAssignment as cpa
ON cpa.NodeID = nodes.NodeID
Inner JOIN orion.npm.CustomPollers AS cp
ON cp.CustomPollerID = cpa.CustomPollerID
INNER JOIN Orion.npm.CustomPollerStatusOnNode as cpson_dia_dc1
ON cpson_dia_dc1.CustomPollerAssignmentID = cpa.CustomPollerAssignmentID and (cpson_dia_dc1.DisplayName like '%DC1-AS-DIA-%')
INNER JOIN Orion.npm.CustomPollerStatusOnNode as cpson_mpls_dc1
ON cpson_mpls_dc1.CustomPollerAssignmentID = cpa.CustomPollerAssignmentID and (cpson_mpls_dc1.DisplayName like '%DC1-AS-MPLS-%')

where (cpson_dia_dc1.Status = 'down' and cpson_mpls_dc1.Status = 'down')