1 of 1 people found this helpful
Are you using this logic to trigger an alert with an email or for something like a dashboard? If you wanted to get that information as part of a report just add this to the select line
,E0.Node.Caption as [Node]
If you are using this query in the alert builder then you don't need to add anything, it already knows how to correlate the poller to the node it is assigned to. You would just go to the email alert action or whatever notification you are using and use the insert variable to find "Caption (Node)" and insert it into your message.