turbot/steampipe-mod-azure-insights

Query: activedirectory_group_type

Usage

powerpipe query azure_insights.query.activedirectory_group_type

Steampipe Tables

SQL

select
'Group Type' as label,
case
when security_enabled then 'Security'
else 'Microsoft 365'
end as value
from
azuread_group
where
id = split_part($1, '/', 1)
and tenant_id = split_part($1, '/', 2);

Dashboards

The query is used in the dashboards: