turbot/azure_insights

Query: resource_group_role_definitions_for_activedirectory_group

Usage

powerpipe query azure_insights.query.resource_group_role_definitions_for_activedirectory_group

SQL

select
d.id as role_definition_id
from
azuread_group as g
left join azure_role_assignment as a on a.principal_id = g.id
left join azure_role_definition as d on d.id = a.role_definition_id
where
(
(a.scope like '%/resourceGroups/%')
or (a.scope like '%/resourcegroups/%')
)
and d.id is not null
and g.id = $1;