How can I Incorporate the parent group of a "Group Down" in an automated Alert Message?

Daran

Hi,

we currently have an automated alert to ServiceNow whenever we have a site Group go down.  Our groups are nested into regions ie.
APAC
- Australia
- Hong Kong
...
EMEA
- Germany
- London
...
NASA
- New York
...
etc.

and our current alert is configured to include this description:

However, our service management team would like us to prepend the message with the Region that the site resides in (i.e. the parent folder.)

I can see from browsing the SW database that there is a solarwinds.containertreesnapshot that seems to show a relationship between a group and its parent group - 

but can anyone tell me what the SWQL would be to incorporate into the Alert above that would result in the message saying something like

NET - Region:EMEA Group:Bulgaria is down

(4 is the ID of the Group named EMEA  in this case, and 6 might be the group for Bulgaria)

thanks,

Daran.

ecmel

The text below should display data in your format:

NET - Region:${N=SWQL;M=SELECT TOP 1 g.Name FROM Orion.Groups g INNER JOIN Orion.ContainerMembers m ON m.ContainerID=g.ContainerID WHERE g.Owner='Core' AND m.MemberEntityType='Orion.Groups' AND m.MemberPrimaryID=${N=SwisEntity;M=ContainerID} ORDER BY g.ContainerID} Group:${N=SwisEntity;M=Name} is ${N=SwisEntity;M=StatusDescription}