Hello All,
I am working on the alerting for routing neighbor, and i have the following query on my alert:
<b>Node Name:</b> ${N=SwisEntity;M=Router.Nodes.DisplayName}
<b>Neighbor Name:</b> ${SQL: SELECT Caption FROM NodesData Where IP_Address='${N=SwisEntity;M=NeighborIP}'}
<b>NeighborIP</b>: <a href="https://orion.xxxx.com/Orion/View.aspx?NetObject=NBR:${NeighborID}">${NeighborIP}</a>
<b>Protocol</b>: ${SQL:SELECT DisplayName FROM NPM_RoutingProtocol WHERE ProtocolID=${ProtocolID}}
<b>Status</b>: ${N=SwisEntity;M=ProtocolStatusDescription} (${SQL:SELECT StatusName FROM StatusInfo WHERE StatusID='${OrionStatus}'})
<b>IsDeleted</b>: ${IsDeleted}
the output i get is correct for a few IPs, but for a few i get the below:
I checked and saw that the IPs that do not resolve to a neighbor name are not the polling IPs of the node and hence i am not getting the neighbor name.
Is there a way i can get the neighbor show up even if the IP is not the polling IP of the node?
Do we have a query for this?
TIA,
Malcolm.
