This Custom query report has been created to display "Domain Users" information for all the users with Employee ID as NULL or Empty String or any User Supplied Value.

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