turbot/oci_insights

Query: identity_users_by_tenancy

Usage

powerpipe query oci_insights.query.identity_users_by_tenancy

SQL

select
t.name as "tenancy",
count(u.*) as "total"
from
oci_identity_user as u,
oci_identity_tenancy as t
where
t.id = u.tenant_id
group by
tenancy
order by
count(u.*) desc;

Dashboards

The query is used in the dashboards: