Can you please assist with creating a query for (active) Support Groups with the following fields:

• Name
• Owned By
• Business Impact
• Description, 
• Technicians interested in this group
• Send notification to group technician(s) when a new request is added to this group (Notify To)
• Send notification to technician(s) when a request in this group is left unpicked (Notify To and Notify After)

We are on Version 9.3 Build 9303, MSSQL.

Many thanks.