I created and alert for our WAN interfaces and need to include the IP address that is assigned to the interface and I'm not finding the variable that I need can someone tell me what I should be looking for?
Here is what I have in the alert email:
This appears (from very limited information) that this is an interface alert. Is that correct?
If so, you can probably use this as the variable (It's a custom SWQL query):
${N=SWQL;M=SELECT CASE WHEN IsNull(IPAddress, '') <> '' THEN CONCAT(IPAddress, ' (', IPAddressType, ')') ELSE '(No IP Detected)' END AS IPFROM Orion.NodeIPAddressesWHERE NodeID = ${N=SwisEntity;M=NodeID} AND InterfaceIndex = ${N=SwisEntity;M=Index}}
IP Addresses are stored in the Orion.NodeIPAddresses entity and are uniquely identified by the Node ID and the Interface Index.
Orion.NodeIPAddresses
It would be more helpful if you could export the entire alert and attach it here as XML if the above doesn't work for you.