A User Report lets you set filters and generate a .xlsx format report on all users that meet those filters. 

Image Removed

Each report contains the following information about each user:

...

contains a wide array of information about your users. Information in this report can be used to research what properties your users have, and how they’re differentiated. This can be used to inform what filters to use when creating /wiki/spaces/CKB/pages/448102401 and setting up your assignment structure.

Table of Contents

To generate a User Report, first navigate to the User Report link under the Reports menu.  You can then set any filters necessary. All filters (other than Status and Hire Date Range) allow multiple entries. For example, you can filter by users with the Supervisor or Instructor roles, and users with at least one of those roles will be included in the output.

...

You can then check boxes for any additional fields you want to include in your report (described in detail below).

...

Finally, click Export Report Data to Excel at the bottom of the screen to generate your report.

Report Output

A User Report will generate an Excel file with information about all users that meet filters that you set.  The report always includes the following information:

• Login ID

• External Unique ID (if enabled)

• First Name

• Preferred First Name (if enabled in System Settings)

• Middle Name

• Last Name

• Hire Date

• Termination Date

• Email Address

• Business Unit

  Division

• District

  Region

• Location

• Training Location

• Training Location expiration

• Job Code

• Supervisor

  Employee

  Login ID

• Supervisor

  ID

  Name

• Supervisor Email Address

• Status

• Department
• Full Time/Part Time
• Is Salaried

  Extended User Properties

• User ID (column hidden in Excel output by default)

Field Display Options

Login Information

...

The following additional information is included:

• Is Registered

• Uses Single Sign On

• First Login Date

• Last Login Date

Account Information

You can add additional information by checking the 'Account Information' checkbox.

The following additional information is included:

• Added Through (User Administration

  or Import

  , Import, or Mass User Upload)

• Created By (name of admin who created account, or N/A if imported)

• Created Date

• Import Status (Import Success, Import Errored, or Not Imported)

• First Import Date

• Last Import Date

• Excluded From Reports (True or False)

• User Report Exclusions (lists reason(s))

• Roles