turbot/oci_insights

Query: ons_notification_topics_for_compute_instance

Usage

powerpipe query oci_insights.query.ons_notification_topics_for_compute_instance

SQL

with jsondata as (
select
topic_id,
tags::json as tags
from
oci_ons_notification_topic
)
select
topic_id as topic_id
from
jsondata,
json_each_text(tags)
where
key = 'CTX_NOTIFICATIONS_COMPUTE_ID'
and value = $1