Identities
Resolve legacy identity information for use with older APIs such as the Security APIs.
View Specific Information
Select
The 本製品 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
| 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).
使用できる値は次のとおりです。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).
使用できる値は次のとおりです。none, direct, expanded, expandedDown, expandedUp |