How To: Generate a Report on 'Child groups under a specific Parent Dynasty along with memberships'

Applies To:

GroupID 9 and 10 - Reports

Business Scenario:

We have a large number of parent/child Dynasty groups in our environment. Is there a report we can run to view a list of all the child Dynasty groups along with memberships for a specific parent Dynasty?

Methodology:

The GroupID Reports module is a free reporting tool designed to run reports on Active Directory, Microsoft Exchange, and Office 365.

Steps:

1. In GroupID Management Console, select Reports > By Category > Groups > Groups and Members.
   
   

2. In the Actions pane, click Create Report. This launches the Create Report wizard.

3. On the Introduction page, read the welcome message and click Next.

4. On the Select View page, select a format for the report and click Next.
   
   

5. By default, the wizard searches the Global Catalog for generating the report. On the Define Scope page, you can limit this scope to a particular container. To do this:

   1. Click Browse to launch the Select Container dialog box and select a source container.
   2. Select the Include sub-containers check box to include its sub-containers when reporting.
   3. In the Edit criteria box, modify the default LDAP filter. This filter is used for selecting items from the containers. Use the criteria provided below:
       

      (&(objectCategory=Group)(objectClass=Group)(displayName=Parent/MiddleDynastyName*)(|(IMSGManagedGroupType=2)(IMSGManagedGroupType=3))(imsgmembersupdatedstatus=*))

       

      Note:

      The * in the LDAP query is necessary with the name of the parent/middle Dynasty as it will act as a wildcard and fetch all groups containing the same displayName. See the following image where I have provided the displayName of my parent Dynasty.

      
      

6. Click Next.
   
   

7. Click Add on the Edit Report Fields page and add the MemberOf field.
   
   

8. You can change the order of fields on the Edit Report Fields page by using the Move Up and Move Down buttons.

9. Click Next.

10. On the Select Sort Field page, select the MemberOf field to generate the list in a hierarchical order.
    
    

11. On the Customize Report page, specify a custom title and a location to save the report. If required, change the default settings.

12. Click Next.

13. The Review Selections page displays a summary of the selections made in the previous steps.

    • Click Next to generate the report with the existing settings.
    • Click Back to go to a previous page and make changes.

14. Once the wizard completes, click Finish. This will open your report in the selected output format.