How to optimize the alerts of neighbor up or neighbor down

antony

When i am using NPM monitor our circuits which connected with each other through ospf/eigrp.And there is a buildin alert neighbor down.

But i think it's not easy to recognize when you have lots of circuits.

I tried to  associate the ip address of the neighbor with its node name.but i failed.Is there anyone did that before?

muckman

I created this SQL macro today for exactly the same use case.

${SQL: SELECT TOP 1 CASE WHEN

(SELECT Caption FROM [SolarWindsOrion].[dbo].[NodesData] WHERE NodeID=(SELECT NodeID FROM [SolarWindsOrion].[dbo].[NodeIPAddresses] WHERE IPAddress='${N=SwisEntity;M=NeighborIP}')) IS NOT NULL

THEN ((SELECT Caption FROM [SolarWindsOrion].[dbo].[NodesData] WHERE NodeID=(SELECT NodeID FROM [SolarWindsOrion].[dbo].[NodeIPAddresses] WHERE IPAddress='${N=SwisEntity;M=NeighborIP}')) + ' (${N=SwisEntity;M=NeighborIP})')

ELSE '${N=SwisEntity;M=NeighborIP}' END}

It will look up the node caption name from the NeighborIP variable but if it can't find a match it will still display the NeighborIP because not all neighbors may be managed by NPM.