How To: Get a Report on Smart Groups with Exchange and External Users

Applies To:

GroupID 9 and 10 - Reports

Business Use Case:

We are moving to Office 365 and users in our domain have fallen out of Smart Groups because their target email address now points to Office 365. We can add these users back to groups from the Query Designer by selecting the Users with external email addresses check box.

However, we have more than 800 Smart Groups in our environment. How can we distinguish between Smart Groups with Exchange users and those with external users?

 Solution:

We do have a report named Smart Groups in current domain in GroupID, that provides a list of all Smart Groups in our domain by applying the following default criterion:

We need to change this criterion for the Smart Groups in current domain report to generate a report on Smart Groups with Exchange users and another report on Smart Groups with external users.

Smart Groups with Exchange users: 

The following criterion will fetch Smart Groups that have Exchange users.

Smart Groups with external users:

The following criterion will fetch Smart Groups with external users.