turbot/azure_insights

Query: activedirectory_group_input

Usage

powerpipe query azure_insights.query.activedirectory_group_input

Steampipe Tables

SQL

select
g.title as label,
g.id || '/' || g.tenant_id as value,
json_build_object(
'tenant', concat('tenant: ', (split_part(g.tenant_id, '-',5))::text),
'group_id', concat('id: ', (split_part(g.id, '-',5))::text)
) as tags
from
azuread_group as g
order by
g.title;