'Detailed Group Members' report gives you a comprehensive membership information about the specified Active Directory Distribution Groups/Security Groups and also all their nested members by recursively querying the specified groups as well as all their nested groups.
With its powerful filters, you can fetch any detail that you need, in the way you need, by choosing to Exclude (Inactive Accounts, Disabled Accounts, etc.) and/or Show Only (Mailbox Enabled Users, Mail Enabled Contacts, etc.) specific categories of accounts as per you need.
There are two views – 'list view,' with the required attributes and their values, for all objects and 'summary view', which gives you a quick snapshot of the entire report, with the count of the matching members in each category, for all the specified objects.
Further, after generating the report, you can refine the result to:
How it works:
'Detailed Group Members' report is generated by querying the 'member' attribute of each specified Active Directory group, to fetch all the members of the group and then the 'filter' is applied to fetch only the required objects and their attributes.
Advantages of 'Detailed Group Members' Report:
FILTERS: This is a highly useful and powerful feature which allows you to specifically select only those categories that you require, for each object, while generating the report. This not only reduces the amount of unwanted data in the report but also generates the report in a shorter time.
COLUMNS: For each selected object, select only the fields that you need in the report. Besides getting the exact data that you require, you also can do away with the unwanted hassle and loss of time in searching for the required fields from the report.
SUMMARY VIEW: Get a snapshot of the entire report in the form of a summary of results for all categories of all the objects selected. From the 'Summary View', you can also view the detailed data for each category by clicking on the result of each category.
FILTERED LIST VIEW: The filtered list view allows you to view the report generated, based on the Active Directory groups for which the report has been generated. After the report has been generated, using the 'Showing members of', the report level filter, you can filter the report by selecting the groups for which you would like to view the report.
Steps to run the report:
Note: To schedule, the 'Detailed Group Members' report has to be scheduled separately, using the 'Schedule Reports' option found in the 'Detailed Group Member' report page.
'Filters' empowers you to select specifically, the exact information that you need in your report. Using 'Filters', you can select only the specific categories of the objects for which you would like to fetch all the required information. Another big plus of 'Filters': you can not only select the categories of objects that you need, you can also select the categories of objects that you would like to exclude while generating the report.
The 'Show Only' option, enables you to view the information about only the specific categories of the object selected.
For example, for 'Groups', you can choose to view in the report, details of only specific categories of Active Directory groups like 'Managed Groups' or 'Security Groups', etc.
The 'Exclude' option allows you to exclude all the information about a specific category(s) of the object from being displayed in the report.
For example, for User objects, you can select any of the available filters like 'Disabled Users', 'Inactive Users', 'Mail Enabled Users', etc. to exclude all the information about the selected category of users from being displayed in the report.
Using the 'Columns' option, for each object that you have selected, you can select specifically those fields or attributes that you require in the report, from the list of all the attributes/fields, including the custom attributes, that are available for that object.
The point to be remembered here is: more the number of fields selected, the more are the chances of the result/report view getting distorted or difficult to read.
Table Format (List View):
In 'Table Format', the result is displayed in the form of table with tabs. All the information about each object is displayed under a separate tab, in addition to the entire result of all the objects which is displayed under one common tab 'All'. This makes reading and understanding the report, easy and simple.
In the table view, you can filter the report by selecting from the Active Directory groups, the groups for which you would like to view the result using the 'Showing members of' filter.
Note: Under the 'All' tab, only those attributes / fields which are common in all the selected objects, like 'samAccountName', 'displayName', 'managedBy', etc., will be displayed.
This view shows you the summary of the entire report, in the form of total number of matching objects. The summary in divided into subsections, with a separate section for each type of object selected.
Also, for each object, you can also view the entire result using the 'Show All Categories' option or view the results for each specific category by clicking on the result of each category.
Viewing only the Commom Members
This option allows you to list only those members who are common to all the selected groups. In other words, this option makes it possible to view the members who are members of all the selected groups.
To list the common members:
Group-specific result view
This option allows you to filter the result based on the groups for which you have generated the report.
To view the result for only specific groups:
To list the common members: