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:
- In GroupID Management Console, select Reports > By Category > Users > Users multiple DL memberships.
-
In the Actions pane, click Create Report. This launches the Create Report wizard.
-
On the Introduction page, read the welcome message and click Next.
-
On the Select View page, select a format for the report and click Next.
-
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:
- Click Browse to launch the Select Container dialog box and select the required source container.
- Select the Include sub-containers check box to include its sub-containers when reporting.
- 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))) -
Click Next.
-
The Edit Report Fields page displays the fields that will be included in the report.
- 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.
- You can also remove a field from the report by selecting it and clicking Remove.
- You can change the order of these fields by using the Move Up and Move Down buttons.
-
Click Next.
-
On the Select Sort Field page, select a field for sorting the data in the report and click Next.
- On the Customize Report page, specify a custom title and a location to save the report. If required, change the default settings.
-
Click Next.
-
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.
-
Once the wizard completes, click Finish. This will open your report in the selected output format.