turbot/oci_insights

Query: ons_notification_topic_unused_count

Usage

powerpipe query oci_insights.query.ons_notification_topic_unused_count

SQL

select
count(*) as value,
'No Subscriptions' as label,
case
count(*)
when 0 then 'ok'
else 'alert'
end as type
from
oci_ons_notification_topic t
left join oci_ons_subscription s on t.topic_id = s.topic_id
where
s.id is null;

Dashboards

The query is used in the dashboards: