turbot/oci_insights

Query: ons_subscription_by_tenancy

Usage

powerpipe query oci_insights.query.ons_subscription_by_tenancy

SQL

select
t.name as "Tenancy",
count(s.id)::numeric as "Subscriptions"
from
oci_ons_subscription as s,
oci_identity_tenancy as t
where
t.id = s.tenant_id
group by
t.name
order by
t.name;

Dashboards

The query is used in the dashboards: