Users

List Users

Table Specific Information

Select

The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

The rest of the filter is executed client-side in the add-in.

UserSK supports the '=,in' operators.

For example:

	
	SELECT * FROM Users WHERE UserSK = '4dbc0cec-c473-652b-972f-f42587b4494d'
	SELECT * FROM Users WHERE UserSK IN ('4dbc0cec-c473-652b-972f-f42587b4494d', '6ddc3cee-c232-634b-342f-f84325b4494d')

Columns


Name	Type	References	Description
ParentReference	String		Parent reference. Only available if IncludeReferenceColumn=true.
UserSK [KEY]	String		User surrogate key.
AnalyticsUpdatedDate	Datetime		Watermark that indicates the last time the Analytics data was updated.
UserEmail	String		Email associated with a user account identity.
UserId	String		Unique identifier assigned to a user account identity.
GitHubUserId	String		GitHub user ID associated with the user account.
UserName	String		The type of user.

Excel Add-In for Azure DevOps

Users

Table Specific Information

Select

Columns