UserMemberships
Provides details of group and directory role memberships for specific users within the organization.
Table Specific Information
Select
Get the memberships of users in your Azure Active Directory. You can filter results by UserId.
- UserId supports the '=' and IN operators.
For example, the following queries are processed server side:
SELECT * FROM UserMemberships WHERE UserId = 'ffacf701-6caf-4228-9e3b-7e57c14122ee'
SELECT * FROM UserMemberships WHERE UserId IN (SELECT Id FROM Users)
Columns
| Name | Type | Description |
| UserId [KEY] | String | The unique identifier for the user associated with this membership. |
| MembershipId [KEY] | String | The unique identifier for the membership entry. |
| classification | String | The classification label used to organize or categorize the membership. |
| createdDateTime | Datetime | The timestamp indicating when the membership was created. |
| creationOptions | String | Options or parameters specified during the creation of the membership. |
| deletedDateTime | Datetime | The timestamp indicating when the membership was deleted, if applicable. |
| description | String | A descriptive label or summary for the membership entry. |
| displayName | String | The human-readable name of the membership used for display purposes. |
| expirationDateTime | Datetime | The timestamp when the membership is set to expire, if applicable. |
| groupTypes | String | The types of groups the membership belongs to, such as 'Unified' or 'Dynamic'. |
| isAssignableToRole | Bool | Indicates whether this membership can be assigned to a role. |
| String | The email address associated with the membership, if applicable. | |
| mailEnabled | Bool | Indicates whether the membership has an active email mailbox. |
| mailNickname | String | The email alias or nickname associated with the membership. |
| membershipRule | String | The rules governing dynamic membership conditions for this group. |
| membershipRuleProcessingState | String | The current state of processing for the dynamic membership rules. |
| onPremisesDomainName | String | The domain name for the membership, synced from on-premises directories. |
| onPremisesLastSyncDateTime | Datetime | The timestamp of the last synchronization with the on-premises directory. |
| onPremisesNetBiosName | String | The NetBIOS name for the membership from the on-premises directory. |
| onPremisesProvisioningErrors | String | Details of any provisioning errors encountered during an on-premises synchronization. |
| onPremisesSamAccountName | String | The Security Account Manager (SAM) account name for the membership. |
| onPremisesSecurityIdentifier | String | The unique security identifier (SID) for the membership from the on-premises directory. |
| onPremisesSyncEnabled | Bool | Indicates whether synchronization with the on-premises directory is enabled. |
| preferredDataLocation | String | The preferred geographic location for storing the membership's data. |
| preferredLanguage | String | The preferred language setting for the membership. |
| proxyAddresses | String | A list of proxy addresses associated with the membership. |
| renewedDateTime | Datetime | The timestamp of the most recent renewal of the membership. |
| resourceBehaviorOptions | String | Behavioral options or settings applied to resources linked to the membership. |
| resourceProvisioningOptions | String | Provisioning options for resources tied to the membership. |
| securityEnabled | Bool | Indicates whether the membership has security features enabled. |
| securityIdentifier | String | The unique security identifier (SID) for the membership. |
| serviceProvisioningErrors | String | Details of any errors during service provisioning for the membership. |
| theme | String | The visual theme or branding applied to the membership. |
| uniqueName | String | A system-generated unique name for the membership. |
| visibility | String | The visibility setting of the membership, such as 'Public' or 'Private'. |