The Out of Box  "Domain Groups with Members" report shows the Distinguished Name for the Managed By for Groups.

This Custom query report has been created to display "Display Name" instead of "Distinguished Name".

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 Report Manager.
  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