AdministrativeUnitMembers
Lists all members of administrative units available to the authenticated user, providing details on their membership relationships.
Table Specific Information
Select
Get the members of administrative units in your Azure Active Directory. You can filter results by UnitId and MemberId.
- UnitId supports the '=' and IN operators.
- MemberId supports the '=' and IN operators.
For example, the following queries are processed server side:
SELECT * FROM AdministrativeUnitMembers WHERE UnitId = '1721e354-9b76-49d5-bdf1-bb30a936c3ab'
SELECT * FROM AdministrativeUnitMembers WHERE MemberId IN (SELECT Id FROM Users)
Columns
| Name | Type | Description |
| UnitId [KEY] | String | The unique identifier of the administrative unit, representing an Azure Active Directory organizational unit. |
| MemberId [KEY] | String | The unique identifier of the user or group that is a member of the specified administrative unit. |