Excel Add-In for Azure Active Directory

Build 24.0.9062

AdministrativeUnitMembers

Retrieves all AdministrativeUnitMembers for the authenticated user.

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 id of the administrativeUnit.
MemberId [KEY] String The User or Group Id of the user listed.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062