Query: List all application role assignments granted for service principals

Description

Explore which principals in your Azure Active Directory have Application Role Assignments for an Azure Active Directory service principal. This information is useful for auditing purposes and ensuring adherence to security protocols.

Query

Tables used in this query:

• azuread_service_principal_app_role_assigned_to

SQL