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 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;

Dashboards

The query is used in the dashboards: