cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 10

Alert on BGP Peer status of "Not Available"

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.

 

hebron1212_0-1592865235114.png

 

Labels (1)
0 Kudos
1 Reply
Level 8

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

0 Kudos