Users
Retrieves a list of users. This table will not retrieve results for the On-premise edition.
Table Specific Information
Select
The driver 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 = '7f1d8582-a070-4d2b'
Insert
The following is an example of inserting into the Users table:
INSERT INTO Users (UserPrincipalName, AccessLevelAccountLicenseType, UserSubjectKind) VALUES ('[email protected]', 'express', 'user')
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 | False |
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. |