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