turbot/azure_insights

Query: activedirectory_user_input

Usage

powerpipe query azure_insights.query.activedirectory_user_input

Steampipe Tables

SQL

select
u.display_name as label,
u.id || '/' || u.tenant_id as value,
json_build_object(
'Tenant', concat('tenant: ', (split_part(u.tenant_id, '-',5))::text),
'UPN', user_principal_name
) as tags
from
azuread_user as u
order by
u.title;