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

SQL for finding out Neighbour name

I have created Slack alert for bgp neighbor down.
I am trying to add the neighbor's name which goes down.

We are using dmvpn. I was wondering if we can fetch the neighbor's name (dmvpn router) for whom the tunnel broke with the tunnel ip.

Can anyone help?

Find more posts tagged with

Accepted answers

All comments

sum_giais

Well hello there!

There could be some fancy ways of pulling it out of topology data in swql but there doesn’t appear to be a variable built in for it. Best is the neighbor IP.

Neighbor IP: ${N=SwisEntity;M=NeighborIP}

Barsha

Hi Sum_giais...

I can pull out the neighbour IP.

We need to send out the alerts to sys team and they will not be able to understand with the neighbour IP.

So I am looking for SQL query which gives the output.

sum_giais

If the neighbor is monitored in SolarWinds there may be other options of being able to pull in the node name by verifying the IP as assigned to that node in SolarWinds itself. However you may be able to try this (I don't have anything with routing neighbors in my home lab so I'm not able to verify..) Not sure if the remote neighbor name is actually something polled or even available. Routing protocols I didn't think share hostnames, however layer2 discovery protocols like lldp, cdp, isdp etc. do. So if the query below doesn't help you, then your only options may be to determine if

1) Is the remote neighbor a monitored SolarWinds node, if so you could join in the node name that way with some crafty swql

and/or

2) If the remote neighbor is running lldp/cdp etc. then you could join in the hostname provided through that protocol

${N=SWQL;M=SELECT DisplayName FROM Orion.Routing.Neighbors WHERE (NeighborIP = '${N=SwisEntity;M=NeighborIP}' AND NeighborIPGUID = '${N=SwisEntity;M=NeighborIPGUID}')}