1 of 1 people found this helpful
You could use a SQL Query against the database. Something like:
SELECT grpName, grpID
WHERE [Protect].[dbo].[ManagedGroups].[grpID] = [Protect].[dbo].[LinkEmailRecManagedGroups].[erecMGmgID]
Assuming your database is named Protect. This is a general idea of the query you could use, and depending on the SQL Server collation and/or your own permissions for query execution, you may need to modify it. Specifically the last line, as you may get an error saying "The multi part identifier could not be bound" if you're unable to make implicit join statements. If you guys have a DBA, he/she can help iron that out.
In this query, grpID and erecMGmgID are both the machine group ID. The query checks between ManagedGroups (your machine groups) and LinkEmailRecManagedGroups (machine groups that have an email recipient, identified by machine group ID), and grabs the machine group name for any ID's that are present in both (i.e, they're set to send emails, and a machine group that currently exists)
If you have to use command line SQL queries the answer is in effect no. OK thank you.