turbot/oci_insights

Query: ons_notification_topic_by_tenancy

Usage

powerpipe query oci_insights.query.ons_notification_topic_by_tenancy

SQL

select
c.title as "Tenancy",
count(t.*) as "Topics"
from
oci_ons_notification_topic as t,
oci_identity_tenancy as c
where
c.id = t.tenant_id
group by
c.title
order by
c.title;

Dashboards

The query is used in the dashboards: