How To: Generate a Report on 'Disabled Users along with DL memberships'

Applies To:

GroupID 9 and 10 - Reports

Business Scenario:

You need a report to view a list of all disabled users along with their DL memberships in the domain.

More Information:

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

Steps to Generate the Report:

1. In GroupID Management Console, select Reports > By Category > Users > Users multiple DL memberships.
   
   

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 the required 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(s).
      The default filter generates a report with all the users in the domain along with their group memberships. Replace it with the LDAP query provided below to fetch a list of all the disabled users within the specified container(s) along with their DL memberships.
       

      (objectClass=user)(userAccountControl:1.2.840.113556.1.4.803:=2)(memberof=*)(!(groupType:1.2.840.113556.1.4.803:=2147483648)))

      

   4. Click Next.

6. 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 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.
      
      

   4. Click Next.

7. On the Select Sort Field page, select a field for sorting the data in the report and click Next.
   
   

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

9. Click Next.

10. 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.

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