'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:
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 common 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: