How To: Generate a Report on 'Groups with no members but at least one owner or additional owner'

Applies To:

GroupID 9 and 10 - Reports

Business Scenario:

You need a report to view a list of all groups that have no members but have an owner or additional owner(s).

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 with no 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 container. The default filter for this report will generate a list of all the groups with no members. Replace it with the following LDAP query to fetch a list of all the groups that have no members; however, have at least one owner or an additional owner.
         

      (&(objectCategory=Group)(objectClass=Group)(!member=*)(managedBy=*)(XAdditionalOwner=*))

      
      

6. Click Next.
   
   

7. The Edit Report Fields page displays the fields that will be included in the report.

   1. To add more fields, click Add. This displays the Add a Field to the Report dialog box where you can select a source field and specify a display name for it.
   2. You can also remove a field from the report by selecting it and clicking Remove.
   3. You can change the order of these fields by using the Move Up and Move Down buttons.

8. Click Next.
   
   

9. On the Select Sort Field page, select the field by which you want to sort the data in the report and click Next.

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

11. Click Next.

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

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

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