GroupApplicationRoleAssignments
GroupApplicationRoleAssignments table for Azure AD data provider.
Table Specific Information
Select
Get the group application roles assignments in your Azure Active Directory. You can filter results by GroupId.
- UserId supports the '=' and IN operators.
For example, the following queries are processed server side:
SELECT * FROM GroupApplicationRoleAssignments WHERE GroupId = 'ffacf701-6caf-4228-9e3b-7e57c14122ee'
SELECT * FROM GroupApplicationRoleAssignments WHERE GroupId IN (SELECT Id FROM Groups)
Columns
| Name | Type | Description |
| GroupId [KEY] | String | The GroupId 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. |