How to Create "All Members and their Groups" Report

Follow

Contents

  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

How_to_Create__All_Members_and_Their_Groups__Report-1.png

Step 2:

Select ALL > Select Format > Clear formatting 

How_to_Create__All_Members_and_Their_Groups__Report-2.png

Step 3:

Select ALL > Select Data > Select Pivot Table

How_to_Create__All_Members_and_Their_Groups__Report-3.png

Step 4:

In Pivot Table 1, Go to Pivot Table Editor on the right hand side.

  • a.) Rows > Add > Select Member Email.
  • b.) Followed by Add  > Select Group Name. The configuration should look like:
How_to_Create__All_Members_and_Their_Groups__Report-4.png

Step 5:

Final report should look like:

How_to_Create__All_Members_and_Their_Groups__Report-5.png
Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request