/
Report: Duplicate User Emails

Report: Duplicate User Emails

Search our help articles

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.

image-20241205-160651.png

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

 

Related content

Report: Duplicate SIS IDs
Report: Duplicate SIS IDs
More like this
Report: Relationship Field Values Uniqueness Test
Report: Relationship Field Values Uniqueness Test
More like this
Dashboard: Duplicate and Missing Values
Dashboard: Duplicate and Missing Values
More like this
Report: URO/FTE Verification
Report: URO/FTE Verification
More like this
Report: Login Statistics
Report: Login Statistics
More like this
Update Email Address
Update Email Address
More like this