ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves a list of users. This table will not retrieve results for the On-premise edition.

Table Specific Information


The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.

For example:

	SELECT * FROM Users WHERE Id = '7f1d8582-a070-4d2b'


The following is an example of inserting into the Users table:

INSERT INTO Users (UserPrincipalName, AccessLevelAccountLicenseType, UserSubjectKind) VALUES ('testemail@example.com', 'express', 'user')


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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479