UserMemberships
Provides details of group and directory role memberships for specific users within the organization.
View-Specific Information
SELECT
You can filter results by UserId.- UserId supports the =, 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'. |