Users

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

Table Specific Information

Select

The connector 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 connector.

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.