Users NOT in Group (Including Employee Type)

ER 2.6.0.13000

Shows all users that are not members of the selected group either directly or indirectly. Employee Type extended attribute is shown.

1. Extract files from the zip file.

2. Backup the currently used database.

3. Run the 'Organizational Unit - Canonical Name input parameter.sql' script to allow OU search

4. Run the 'Fix for [dbo].[NestedGroupMembersForAccount].sql' script to allow to get indirect members which are more than 10 levels deep.

5. Import the 'Users NOT in Group.xrd' report

6. Set domain and group, and run the report.

Anonymous