Report: Duplicate SIS IDs

Description: This SQL report counts the number of distinct LMS user IDs attached to each SIS ID value. 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 SIS IDs report to identify SIS ID values associated with multiple unique LMS user IDs, enabling streamlined data management and user account reconciliation.

Open

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