Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SWQL Query for BGP Percent Route Loss

I am trying to work on a SWQL query for BGP percent route loss. Looking in SWQL Studio though, I am not too sure what table I should be working with to get these metrics to create the query around. Currently, I am looking at the NCM.RouteTable, but I am at a loss where to even begin other than that. I am hoping someone would be able to assist and would GREATLY appreciate it.

Where my thoughts are currently, is taking a total number of BGP routes and infer a percentage of 'loss' based on the number of of available routes and those that are up/down. But again, I am not sure where to find these in the table I am looking at.

Find more posts tagged with

Accepted answers

All comments

adam.beedell

1st reaction - BGP percent loss??
2nd reaction - Ok, that would make sense.. You'd group by the startpoint I suppose, as in GROUP BY NODEID, then I guess you could CASE the BGP info into up/down statuses, then Count the IDs GROUPED BY the Status, then I guess divide those into a percentage. Feels maybe a little harder than necessary, could be built though.

Matthew.Frias

So that's along the lines of the logic of how I want to do it, but I am unsure what table I would pull from to get up/down status and be able to filter by 'BGP'. I poked around some other tables and generated a query to start altering, but I am unsure if I'm going down the right rabbit hole for this. Below is the query so far as follows:

SELECT TOP 10 NodeID, Poller, LastPoll, NextPoll, ErrorMessage, CompleteValues, Description, rd.Router.RoutingTable.RouteID,

COUNT(rd.Router.RoutingTable.RouteID) AS [Total Numer of Routes]

FROM Orion.Routing.RoutingDetails rd

GROUP BY NodeID, Poller, LastPoll, NextPoll, ErrorMessage, CompleteValues, Description, rd.Router.RoutingTable.RouteID

It's not much, but I am mainly trying to get the data needed right now to manipulate to get the final product. And by BGP percent loss, what was requested by me is to see if there is a way to have SolarWinds take the BGP routes as a total, and alert when 30% are lost.

adam.beedell

Might sound silly but I'd check the requestor means what you think they mean - I can just imagine it actually being something like:
Ping each neighbor, report %down

Aside from that to filer by BGP usually it's something like Select/join to Orion.Routing.Neighbors rn ... where rn.ProtocolName like 'bgp'

jodelgado

I do "show BGP Sum" on the router to look at the number of BGP " active routes, received routes, accepted routes, and damped routes" get the OID for your specific router which would display these values and create a custom poller if the number of routes drop.

I do this in our environment and works just fine.

good luck.