Am I missing something? This must be pretty obvious, but I can't find anywhere what is a variable for the Interface IP Address. Would anyone please help?
I am trying to use this variable in Map ToolTips and in Email Alerts
Hello,
Could you please try SQL variable:
${SQL:SELECT TOP 1 I.IPAddress FROM NodeIPAddresses as I join Interfaces as inter on I.nodeid=inter.nodeid and inter.interfaceindex=i.interfaceindex where inter.interfaceid=${InterfaceID}}
Thanks
LadaVarga,
Thanks for your reply, but this unfortunately didn't work.
Where did not work? I tried in Advanced Alert manager and create Alert action: Send meesage to netperfmon log and it is working.
Write it some error?
LadaVarga
I have used it in Map ToolTips for the interface and it didn't return IP address:
Hello alexslv,
Unfortunately Map tooltips doesn't support SQL variable. For this please create feature request.
For Alert message this should be work
Lada
OK, thanks, I appreciate your help Lada
It should be ${IP_Address}.
There is an old reference document, which I believe is still valid for the variable names, which is also listed in the main NPM admin guide.
http://www.solarwinds.com/documentation/orion/docs/OrionNetworkAtlasAdminGuide.pdf
${IP_Address} Node IP address, It is Node ip adress not Interface IP adress.
What we need is something like ${InterfaceIP} in:
Interfaces
Variable
Description
${InterfaceID}
Unique ID of the interface. Network Performance Monitor assigns a unique ID to every network object.
${InterfaceCaption}
User-assigned name for this interface
${Index}
Index of the interface within the network node.
${InterfaceType}
Numerical type of the interface. This information is collected by Network Performance Monitor when discovering the network node.
${Description}
Description of the interface.
${MAC}
Physical address (MAC Address) of the interface
${MTU}
Maximum Transmission Unit
${InterfaceSpeed}
Speed of the Interface discovered by Network Performance Monitor when scanning the network node
${InterfaceName}
Name of the interface discovered from the node
${InterfaceIcon}
Icon depicting the type of interface (Ethernet, Frame-Relay, ATM, Token Ring, wireless, etc).
${NodeID}
ID of the Network Node to which this interface belongs. Network Performance Monitor assigns a unique ID to every network object.
${InterfaceTypeName}
Type of interface. Discovered from ifType.
${FullName}
Full name of the interface including the name of the network node it is in
${Counter64}
Interface supports IF-MIB high-capacity counters
