GroupMembers
Provides a detailed view of group memberships, listing all members of each group within the organization.
Table Specific Information
Select
Query the GroupMembers table by retrieving everything from Azure AD or by specifying the GroupId with = and IN operators. You can filter results by GroupId and MemberId.
- GroupId supports the '=' and IN operators.
- MemberId supports the '=' and IN operators.
For example, the following queries are processed server-side:
SELECT * FROM GroupMembers WHERE GroupId IN ('4729c5e5-f923-4435-8a41-44423d42ea79', 'acabe397-8370-4c31-aeb7-2d7ae6b8cda1')
SELECT * FROM GroupMembers WHERE GroupId = '4729c5e5-f923-4435-8a41-44423d42ea79'
Columns
| Name | Type | Description |
| GroupId [KEY] | String | The unique identifier of the group, representing a specific collection of users or entities in Azure Active Directory. |
| MemberId [KEY] | String | The unique identifier of a user or entity that belongs to the specified group in Azure Active Directory. |