This view gives mapping of user to group.
Back to Reporting SQL Views.
Field Name | DB Type | Type | Nullable | Description |
---|---|---|---|---|
UserId | uniqueidentifier | Guid | 0 | The user's ID. |
Username | nvarchar | String | 0 | The username of the user. |
Groupname | nvarchar | String | 0 | The name of the group to which the user belongs. |
GroupId | uniqueidentifier | Guid | 0 | The ID of the group to which the user belongs. |