Identities
Resolve legacy identity information for use with older APIs such as the Security APIs.
View Specific Information
Select
The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=,in' operators.
- Descriptor supports the '=,in' operators.
- SubjectDescriptor supports the '=,in' operators.
- SearchFilter supports the '=' operator. Note that the FilterValue must also be specified.
- FilterValue supports the '=' operator. Note that the SearchFilter must also be specified.
Note that the API requires a filter, so if no filter is specified by the user, then the driver will automatically add the filter 'WHERE Id IN (SELECT Id FROM Users)'.
For example:
SELECT * FROM Identities WHERE Id IN ('016a5631-0d32-6644-ab69-b1baf02fdb5c','1356ed53-6784-661a-b5d1-7c080ec0c928')
SELECT * FROM Identities WHERE SubjectDescriptor = 'vssgp.Uy0xKTktMTU1MTM3NDI0RS0zMjA2MTU1Njc2LTE2Njk1MzM1MDUtMzE1NTcwNTg2Mi0yODc4NzY2ODE4LTAtMC0wLTAtMQ'
SELECT * FROM Identities WHERE SearchFilter ='General' AND FilterValue='[email protected]'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Identity Identifier. Also called Storage Key, or VSID. | |
| Descriptor | String | A wrapper for the identity type. | |
| SubjectDescriptor | String | Subject descriptor of a Graph entity. | |
| ProviderDisplayName | String | The display name for the identity as specified by the source identity provider. | |
| IsActive | Boolean | True if the identity has a membership in any Azure Devops group in the organization. | |
| IsContainer | Boolean | True if the identity is a group. | |
| MemberIds | String | Id of the members of the identity (groups only). | |
| MemberOf | String | A wrapper for the identity type (Windows SID, Passport) along with a unique identifier such as the SID or PUID. | |
| Members | String | A wrapper for the identity type (Windows SID, Passport) along with a unique identifier such as the SID or PUID. | |
| MetaTypeId | Integer | Meta Type Id. | |
| ResourceVersion | Integer | Resource Version. | |
| Properties | String | Key-value pairs for the property bag. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
| Name | Type | Description | |
| SearchFilter | String | The type of search to perform. Must be used with FilterValue. Values can be AccountName (domain\alias), DisplayName, MailAddress, General (display name, account name, or unique name), or LocalGroupName (only search Azure Devops groups).
The allowed values are AccountName, DisplayName, MailAddress, General, LocalGroupName. | |
| FilterValue | String | The search value, as specified by the searchFilter. Must be used with SearchFilter. | |
| QueryMembership | String | The membership information to include with the identities. Values can be None for no membership data or Direct to include the groups that the identity is a member of and the identities that are a member of this identity (groups only).
The allowed values are none, direct, expanded, expandedDown, expandedUp. |