Report: Duplicate User Emails

Description: This SQL report counts the number of distinct LMS user IDs attached to each Email address. A concatenated list of Username values is included, delimited by a semicolon (;). The report can be sorted by the "Unique Users" column.

Roles that may benefit from this report:

LMS Administrators: Can use the Duplicate User Emails report to identify emails associated with multiple unique LMS users, enabling streamlined data management and user account reconciliation.

Columns in Report:
Column Data Descriptions can also be found in the Data Dictionary in the help bar of IntelliBoard

Total Number of Users assigned to the email address

All the Usernames associated with the email addres