RoleDefinitions
Retrieves the Role Definitions for the Azure AD.
Table Specific Information
Select
Most filters are handled server side, but the specific field of Id will change the endpoint we use to retrieve the data. It must be specified with an '=' or IN condition.
For example:
SELECT * FROM RoleDefinitions WHERE Id = '62e90394-69f5-4237-9190-012177145e10'
SELECT * FROM RoleDefinitions WHERE Id IN ('62e90394-69f5-4237-9190-012177145e10', 'fe930be7-5e62-47db-91af-98c3a49a38b1')
SELECT * FROM RoleDefinitions WHERE DisplayName LIKE '%Admin%'
Columns
| Name | Type | Description |
| id [KEY] | String | The id of the roleDefinition. |
| allowedPrincipalTypes | String | The allowedPrincipalTypes of the roleDefinition. |
| description | String | The description of the roleDefinition. |
| displayName | String | The displayName of the roleDefinition. |
| isBuiltIn | Bool | Indicator if roleDefinition is Builtin. |
| isEnabled | Bool | Indicator if roleDefinition is Enabled. |
| isPrivileged | Bool | Indicator if roleDefinition is Privileged. |
| resourceScopes | String | The resourceScopes of the roleDefinition. |
| rolePermissions | String | The rolePermissions of the roleDefinition. |
| templateId | String | The templateId of the roleDefinition. |
| version | String | The version of the roleDefinition. |