How can I ignore Idle (Admin) BGP neighbors in Alerts?

Problem: Until I find time to go through all my gear and delete unused peering sessions,  I'd like to make Solarwinds ignore BGP neighbors with the following state: Idle (Admin)

You'll see this if you do a sh ip bgp sum and you have an admin down BGP peer.

Currently I only have the first gray child condition, Routing Neighbors Protocol Orion Status is equal to Down.  The 3 gray child conditions listed under the AND statement are ones that I was considering tinkering with if it will accomplish the task.

I was thinking that all I need to do is tell the Alerts to IGNORE Idle (Admin) bgp states this would solve my problem for now.  It doesn't look like there is a way to do this.  Can anyone give a suggestion (besides delete the bgp peers bc yeah yeah it's on my list)?

pastedImage_1.png

Here are some other options to choose from:

pastedImage_0.png

Parents
  • I was able to accomplish this with a Universal Device Poller and a Custom SQL Alert.

    In the Universal Device Poller app on my primary poller, I added the previously mentioned OID: 1.3.6.1.2.1.15.3.1.3

    UniversalDevicePoller.png

    Once the poller is defined, "Assign Pollers" to apply it to nodes. I selected all my Cisco inventory. I don't know if it will dynamically apply this poller to new devices or not.

    Next, create a new alert. The alert type is "Custom SQL Alert (Advanced)", then selected "Routing Neighbors" for "Set up your SQL condition".

    CustomSQLAlert.png

    When "Routing Neighbors" is selected, it will pre-populate the first part of the query. This part is not editable:

    SELECT NPM_RoutingNeighbor_V.NeighborIP, NPM_RoutingNeighbor_V.NeighborID FROM NPM_RoutingNeighbor_V

    Next, add more to the query. This will join the NPM_RoutingNeighbor_V table with the CustomPollerStatusTable. OrionStatus=2 means the neighbor is down. Value=2 means the admin status is enabled. ProtocolID=14 is to specify BGP only.

    LEFT JOIN CustomPollerStatusTable AS p

    ON NPM_RoutingNeighbor_V.NodeID=p.NodeID AND NPM_RoutingNeighbor_V.NeighborIP=p.RowID

    WHERE OrionStatus=2 AND p.Value=2 AND NPM_RoutingNeighbor_V.ProtocolID=14

Reply
  • I was able to accomplish this with a Universal Device Poller and a Custom SQL Alert.

    In the Universal Device Poller app on my primary poller, I added the previously mentioned OID: 1.3.6.1.2.1.15.3.1.3

    UniversalDevicePoller.png

    Once the poller is defined, "Assign Pollers" to apply it to nodes. I selected all my Cisco inventory. I don't know if it will dynamically apply this poller to new devices or not.

    Next, create a new alert. The alert type is "Custom SQL Alert (Advanced)", then selected "Routing Neighbors" for "Set up your SQL condition".

    CustomSQLAlert.png

    When "Routing Neighbors" is selected, it will pre-populate the first part of the query. This part is not editable:

    SELECT NPM_RoutingNeighbor_V.NeighborIP, NPM_RoutingNeighbor_V.NeighborID FROM NPM_RoutingNeighbor_V

    Next, add more to the query. This will join the NPM_RoutingNeighbor_V table with the CustomPollerStatusTable. OrionStatus=2 means the neighbor is down. Value=2 means the admin status is enabled. ProtocolID=14 is to specify BGP only.

    LEFT JOIN CustomPollerStatusTable AS p

    ON NPM_RoutingNeighbor_V.NodeID=p.NodeID AND NPM_RoutingNeighbor_V.NeighborIP=p.RowID

    WHERE OrionStatus=2 AND p.Value=2 AND NPM_RoutingNeighbor_V.ProtocolID=14

Children