Alert on BGP Peer status of "Not Available"

hebron1212

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.

sw2174873

You can try the below query and check if it is working for you

SELECT

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]

,rn.LastChange

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

where rn.IsDeleted='False'

Order by rn.ProtocolStatusLED desc