Users
Retrieves a list of users. This table will not retrieve results for the On-premise edition.
Table Specific Information
Select
The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=' operator.
For example:
SELECT * FROM Users WHERE Id = 'c774bab2-7c43-65da-8ae4-be3ca4519257'
Insert
When performing an Insert, the following fields are required: UserPrincipalName, UserOriginID, AccessLevelAccountLicenseType
The following is an example of inserting into the Users table:
INSERT INTO Users (UserDisplayName, UserPrincipalName, UserOriginID, AccessLevelAccountLicenseType, UserSubjectKind) VALUES ('Anirudh', '[email protected]', '000300003732A094', 'express', 'user')
Update
Updates are not supported for this table. However, they can be performed through the UpdateUser stored procedure.
Delete
Due to the fact that there is no way to distinguish between the API response for a successful and a failed DELETE for this table, the affected row count is always -1.
The following is an example of deleting from the Users table:
DELETE FROM Users WHERE Id = '7342ddfe-abc9-4884-9fbf-773be61e2c92'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Id of the User. | |
| AccessLevelAccountLicenseType | String | False |
Type of Account License (e.g. Express, Stakeholder etc.). | |
| AccessLevelAssignmentSource | String | False |
Assignment Source of the License (e.g. Group, Unknown etc.). | |
| AccessLevelLicenseDisplayName | String | False |
Display name of the license. | |
| AccessLevelLicensingSource | String | False |
Licensing Source (e.g. Account. MSDN etc.). | |
| AccessLevelMSDNLicenseType | String | False |
Type of MSDN License (e.g. Visual Studio Professional, Visual Studio Enterprise etc.). | |
| AccessLevelStatus | String | False |
User status in the account. | |
| AccessLevelStatusMessage | String | False |
Status message. | |
| DateCreated | Datetime | True |
Date the user was added to the collection. | |
| LastAccessedDate | Datetime | True |
Date the user last accessed the collection. | |
| UserDescriptor | String | False |
The descriptor is the primary way to reference the user while the system is running. | |
| UserDirectoryAlias | String | False |
The short, generally unique name for the user in the backing directory. | |
| UserDisplayName | String | False |
This is the non-unique display name of the graph subject. | |
| UserDomain | String | False |
This represents the name of the container of origin for a graph member. | |
| UserMailAddress | String | False |
The email address of record for a given graph member. | |
| UserMetaType | String | False |
The meta type of the user in the origin, such as 'member', 'guest', etc. | |
| UserOrigin | String | False |
The type of source provider for the origin identifier (ex:AD, AAD, MSA). | |
| UserOriginId | String | False |
The unique identifier from the system of origin. | |
| UserPrincipalName | String | False |
This is the PrincipalName of this graph member from the source provider. | |
| UserSubjectKind | String | False |
This field identifies the type of the graph subject. | |
| UserUrl | String | False |
This url is the full route to the source resource of this graph subject. |