This Custom Query has been created to show the direct and indirect users that are members of the selected groups and show the comparison as well.

You will need to run the SQL queries inside the "SQL_To_Add_Groups_GroupMembershipComparison.sql" 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 you can specify maximum of 5 groups to compare in this report.

Version: ER 2.5.1 HF 3