User Rights with Nested Group Membership

The Out of Box  "User Rights" report doesn't show any group memberships and attributes for Domain or Local Users.

This Custom Query has been created to show the nested group memberships in the User Rights report.

You will need to run the SQL queries inside the "SQL_To_Execute.txt" file before importing the custom report. Make sure to backup your database.

Steps to import this report is as follows:

1. Save the attached xrd file on to your computer.
2. Open Report Manager.
3. Go to My Reports.
4. Click on Import and browse to the location where you saved the .xrd file.
5. Click on Open, that should import the report.

Please note that we only support * for the wild card for this report.

Version: ER 2.5.1 HF 3

Thanks,

Aarti