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. |
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. |