GroupApplicationRoleAssignments
Tracks application role assignments assigned to specific groups for managing permissions.
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 unique identifier for the group associated with the application role assignment. |
id [KEY] | String | The unique identifier for the application role assignment. |
appRoleId | String | The unique identifier of the specific application role being assigned to the group. |
createdDateTime | Datetime | The date and time when the application role assignment was created. |
principalDisplayName | String | The display name of the principal (for example, user, group, or service principal) involved in the role assignment. |
principalId | String | The unique identifier of the principal (for example, user, group, or service principal) associated with the role assignment. |
principalType | String | The type of the principal (for example, user, group, or service principal) involved in the role assignment. |
resourceDisplayName | String | The display name of the resource (for example, application or service) associated with the role assignment. |
resourceId | String | The unique identifier of the resource (for example, application or service) to which the role assignment applies. |