GroupMembers

Get direct members of a group.

Table Specific Information

Select

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

Id supports the '=' operator.
GroupId supports the 'in' operator.

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

For example:

SELECT * FROM GroupMembers WHERE Id='b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND GroupId='837ccd31-8159-4db3-b8ce-de0c36d2a0bf'

Insert

When performing an Insert, the following fields are required: Id, GroupId

Sample insert:

INSERT INTO GroupMembers (Id, GroupId) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', '837ccd31-8159-4db3-b8ce-de0c36d2a0bf')

Update

UPDATEs are not supported for this table.

Delete

Sample delete:

DELETE FROM GroupMembers WHERE GroupId='837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Id='b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		Unique identifier of the group member.
GroupId [KEY]	String	False	Groups.OriginId	OriginId of the group.
DateCreated	Datetime	True		Date the user was added to the collection.
LastAccessedDate	Datetime	True		Date the user last accessed the collection.
AccountLicenseType	String	True		Type of Account License.
AssignmentSource	String	True		Assignment Source of the License.
GitHubLicenseType	String	True		GitHub license type.
LicenseDisplayName	String	True		Display name of the License.
LicensingSource	String	True		Licensing Source.
MsdnLicenseType	String	True		Type of MSDN License.
AccessLevelStatus	String	True		User status in the account.
AccessLevelStatusMessage	String	True		Status message.
UserDescriptor	String	True		The primary way to reference the graph subject while the system is running.
UserDirectoryAlias	String	True		The short, generally unique name for the user in the backing directory.
UserDisplayName	String	True		The non-unique display name of the graph subject.
UserDomain	String	True		The name of the container of origin for a graph member.
UserMailAddress	String	True		The email address of record for a given graph member.
UserMetaType	String	True		The meta type of the user in the origin, such as 'member', 'guest', etc.
UserOrigin	String	True		The type of source provider for the origin identifier (ex:AD, AAD, MSA).
UserOriginId	String	True		The unique identifier from the system of origin. Typically a sid, object id or Guid.
UserPrincipalName	String	True		PrincipalName of this graph member from the source provider.
UserSubjectKind	String	True		This field identifies the type of the graph subject (ex: Group, Scope, User).
UserUrl	String	True		This url is the full route to the source resource of this graph subject.
Extensions	String	True		Extensions.
GroupAssignments	String	True		GroupEntitlements that this user belongs to.
ProjectEntitlements	String	True		Relation between a project and the member's effective permissions in that project.