User View

This SQL View provides details for all users in the system.

Back to Reporting SQL Views.

Field Name DB Type Type Nullable Description
UserId uniqueidentifier Guid 0 User ID.
Username nvarchar String 0 The username of the user. Format: Domain/username
DisplayName nvarchar String 0 The display name of the user.
FirstName nvarchar String 0 The first name of the user.
LastName nvarchar String 0 The last name of the user.
Email nvarchar String 0 The user's email.
State bit Boolean 0 The state of the user. Enabled = 0, Disabled =1, Deleted = 2
CreatedDate datetime DateTime 0 The date on which the user was created.
ModifiedDate datetime DateTime 0 The date on which user details were last modified.