Users
Retrieves a list of users. This table will not retrieve results for the On-premise edition.
Table Specific Information
Select
The provider 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
The Update operation is not supported for this table.
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. |