turbot/oci_insights

Query: identity_user_input

Usage

powerpipe query oci_insights.query.identity_user_input

SQL

select
u.name as label,
u.id as value,
json_build_object(
't.name', t.name
) as tags
from
oci_identity_user as u
left join oci_identity_tenancy as t on u.tenant_id = t.id
order by
u.name;