There's been a few posts in the past but I do not see a working solution posted yet. Hoping someone who is good at SQL/SWQL can help find a way.
This post has a picture of what looks like having a interface included in their routing table but they did not say how they did it. I've not been able to find a table containing the related interface to the "down" routing neighbor ip.
I tried using the builder to make this but it doesn't work, it returns 0 results when we know we have down bgp neighbors. I think because it can't join these tables for some reason or can't find a link between the two?. We are trying to key off the interface caption/alias/description as it has our mpls circuit info in there and we use "ckt" as a key to pull from.
We also want to do a similar table/report for EIGRP and OSPF too.
Here is one you can see is showing two interfaces, only one neighbor is down and on this router there are two interfaces with "ckt" in them so how do we show only the relevant one to the neighbor that is down? It is causing our noc to open tickets to the wrong circuit.
I am wondering if using SWQL instead would be better for this somehow. I could not find a table containing the interface AND an obvious link to the routing protocols running on that interface. Possibly as a last resort we can use the neighbor IP address and "subtract one" from the last octet and use that to lookup the interface ip of our cpe router and use that to grab the right info? I am just not totally sure how to do that or if it would work.
