I have made a alert that trigger when a BGP Routing Neighbors is going down. I will then have an email from which node and to which node the BGP routing neighbor went down example:
---------------
Subject: BGP routing Neighbors is down from NODE1 to NODE2
An issue on an object you are monitoring occurred at Never.
View full object details here: ${N=SwisEntity;M=DetailsUrl}.
View full alert details here:
Click here to acknowledge the alert:
This message was brought to you by the alert named: SB1 Stamnett BGP ruting endring
---------------
If you see in the detail on the node i can see the node name for the BGP routing neighbor but i have no choice to select the node name for the routing neighbor in the trigger action and mail.

Does anyone have a SQL script or something similar that can retrieve this info to put this in the mail that is sent out when the alarm is triggered. Or any others solution?