turbot/oci_insights

Query: vcn_flow_logs_for_vcn_vcn

Usage

powerpipe query oci_insights.query.vcn_flow_logs_for_vcn_vcn

SQL

select
l.id as flow_log_id
from
oci_logging_log as l,
oci_core_subnet as s
where
configuration -> 'source' ->> 'service' = 'flowlogs'
and configuration -> 'source' ->> 'resource' = s.id
and s.vcn_id = $1;