Attempting to build an alert that looks first at the BGP Idle status, then checks if the related interface is a custom property of WAN=Y and Interface Operational Status is = Up with Interface Admin status = Up
One would assume this is simple within the web Alert Manager, but try it, its not... Once you switch from the Primary Trigger of Routing Neighbors to the Secondary condition of Interfaces the alert fires regardless of interface status
Trigger Condition:
Routing Neighbors - Protocol Orion Status - is not equal to - Up
And
All child conditions must be satisfied (AND)
Interfaces Custom Properties - WAN - is equal to - Y
Interface - Operational Status - is equal to - Up
How can i get this SQL Query into an advanced alert using Custom SQL Alert (Advanced) or Custom SWQL Alert (Advanced):
SELECT *
From
NPM_RoutingNeighbor INNER JOIN Interfaces
ON (NPM_RoutingNeighbor.NodeID = Interfaces.NodeID)
where
NPM_RoutingNeighbor.protocolID = '14' /*BGP*/
AND NPM_RoutingNeighbor.ProtocolStatus = '1' /*Idle*/
AND Interfaces.WAN = 'Y' /*Custom Interface Property*/
AND (Interfaces.OperStatus <>'2' /*up*/
AND Interfaces.AdminStatus = '1') /*up*/