turbot/oci_insights

Query: compute_instances_for_ons_notification_topic

Usage

powerpipe query oci_insights.query.compute_instances_for_ons_notification_topic

SQL

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