Hi Guys,
I a little stuck on this one and need some help.
I have been trying to get some VRF Name information into the BGP Email Alerts we recieve and I created a custom SQL Variable..
Below is the syntax I have used in the message;
This alert was generated on ${N=Alerting;M=AlertTriggerTime;F=DateTime}.
The following Node: ${N=SwisEntity;M=Router.Nodes.Caption}
Node IP Address: ${N=SwisEntity;M=Router.Nodes.IP_Address}
Node SiteCode: ${N=SwisEntity;M=Router.Nodes.CustomProperties.SiteCode}
BGP Neighbor AS: ${N=SwisEntity;M=AutonomousSystem}
VRF Name: ${SQL: SELECT v.Name FROM NPM_VRFs v JOIN NPM_RoutingNeighbor RN ON v.NodeID = RN.NodeID WHERE v.Name=${N=SwisEntity;M=NeighborID}}
BGP Neighbor ID: ${N=SwisEntity;M=NeighborID}
BGP Neighbor IP Address: ${N=SwisEntity;M=NeighborIP}
BGP Neighbor Status: ${N=SwisEntity;M=ProtocolStatusDescription}
When I receive the email i get the below;
BGP Neighbor AS: 65534
VRF Name: MACRO SQL ERROR - Conversion failed when converting the nvarchar value 'mgmtVrf' to data type int.
BGP Neighbor ID: 448993
BGP Neighbor IP Address: x.x.x.x
BGP Neighbor Status: Idle
All I want it to do is take the VRF Name that matches it's Neighbor ID..
Any Help would be greatly appreciated
Thanks