Do you want to have the network topology information in an alert email? Showing what nodes are connected to the node that the alert is triggering on. Do you want this kind of info in the alert?
With below SQL variable its possible. No, it will not be as fancy as above but at least the info is there (if you want to improve below query to add more style to it, be my guest!!)
In the alert email action, make sure to set the email to be html formatted instead of plain text and add below code:
${SQL:SELECT TOP 20
replace(replace(
(
SELECT
SN.Caption + ': ' + ISNULL(SI.Caption,’unknown’) + ' <-> ' + ISNULL(DI.Caption,’unknown’) + ': ' + DN.Caption + '
'
FROM TopologyConnections AS T
INNER JOIN NodesData as SN on T.SourceNodeID=SN.NodeID
INNER JOIN NodesData as DN on T.MappedNodeID=DN.NodeID
LEFT OUTER JOIN Interfaces AS SI ON T.SourceInterfaceID=SI.InterfaceID
LEFT OUTER JOIN Interfaces AS DI ON T.MappedInterfaceID=DI.InterfaceID
WHERE
T.DataSourceNodeID=${N=SwisEntity;M=NodeID}
ORDER BY SN.Caption,SI.Caption
FOR XML PATH ('')
), '<', '<'), '>', '>')
}
And you will get something like this in your email alerts:
Good luck!!
(Edit: Updated the code a bit)
