How to Create "All Members and their Groups" Report



  1. All Groups and Their Members
  2. Clear Formatting
  3. Select Pivot Table
  4. Add fields
  5. Finish

BetterCloud does not currently have a report that shows all the users on your domain and the groups that they are in, but this article will show you how to easily modify an existing report to create this.

**This will only display users that are members of groups

Step 1:

Run the report "All Groups and Their Members" from the Canned Reports section

Step 2:

Select ALL > Select Format > Clear formatting

Step 3:

Select ALL > Select Data > Select Pivot Table Report

Step 4:

In Pivot Table 1, Go to Report Editor on Right Hand Side.

  • a.) Rows > Add Field > Select Member Email.
  • b.) Followed by Add Field > Select Group Name. Should look like:

Step 5:

Final Report Should Look Like:

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request