UserApplicationRoleAssignments
UserApplicationRoleAssignments table for Azure AD data provider.
Table Specific Information
Select
Get the user application roles assignments 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 UserApplicationRoleAssignments WHERE UserId = 'ffacf701-6caf-4228-9e3b-7e57c14122ee'
SELECT * FROM UserApplicationRoleAssignments WHERE UserId IN (SELECT Id FROM Users)
Columns
| Name | Type | Description |
| UserId [KEY] | String | The UserId of the ApplicationRoleAssignment. |
| id [KEY] | String | The id of the ApplicationRoleAssignment. |
| appRoleId | String | The appRoleId of the ApplicationRoleAssignment. |
| createdDateTime | Datetime | The createdDateTime of the ApplicationRoleAssignment. |
| principalDisplayName | String | The principalDisplayName of the ApplicationRoleAssignment. |
| principalId | String | The principalId of the ApplicationRoleAssignment. |
| principalType | String | The principalType of the ApplicationRoleAssignment. |
| resourceDisplayName | String | The resourceDisplayName of the ApplicationRoleAssignment. |
| resourceId | String | The resourceId of the ApplicationRoleAssignment. |