Is it possible to alert on this BGP status of "Not Available" as shown in the GUI? I know it's not an actual BGP status, but just probably NPM is not able to get the information from the router and/or database. Nevertheless, it could be useful in an alert. This is on the Networks tab of the router's Node Details page.
You can try the below query and check if it is working for you
TOUPPER(SUBSTRING(n.caption,1,case when charindex('.',n.caption,1) <=4
then length(n.caption) else (charindex('.',n.caption,1)-1) end)) as [Node]
,n.DetailsUrl AS [_LinkFor_Node]
,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node]
,case when nn.Caption is not NULL then nn.Caption else rn.NeighborIP end as [Neighbor]
,case when nn.Caption is not NULL then nn.DetailsUrl end as [_LinkFor_Neighbor]
,case when nn.Caption is not NULL then concat('/Orion/images/StatusIcons/Small-',nn.StatusIcon) end as [_IconFor_Neighbor]
,rn.ProtocolName as [Protocol]
,case when rn.ProtocolStatusLED=1 then '/Orion/images/StatusIcons/Small-Up.gif'
when rn.ProtocolStatusLED=2 then '/Orion/images/StatusIcons/Small-Down.gif' end as [_iconfor_Protocol]
,rn.AutonomousSystem as [Remote AS]
,case when rn.ProtocolStatusDescription is NULL then 'N/A' else rn.ProtocolStatusDescription end as [Status]
FROM Orion.Routing.Neighbors rn
join Orion.nodes n on n.nodeid=rn.nodeid
left join Orion.NodeIPAddresses **bleep** on **bleep**.IPaddress=rn.NeighborIP
left join Orion.Nodes nn on nn.nodeid=**bleep**.nodeid
Order by rn.ProtocolStatusLED desc
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.