I’m a beginner in Transact-SQL.

Currently I´m trying to create a query that allows me to establish a connection between a group and an alarm in the SCOM DWH.

The goal is to list a specific alarm with members of a specific group.


With this query I can show all alarms with a specific AlertName:




And with this query I can get a list of all groups:




Now I tried to combine both querys but without success.



I get a result but not that what I want to have..


Any ideas?

Tom79 asked