0

Hello!

 

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