turbot/oci_insights

Query: vcn_vcns_for_compute_instance

Usage

powerpipe query oci_insights.query.vcn_vcns_for_compute_instance

SQL

select
s.vcn_id as vcn_id
from
oci_core_subnet as s,
oci_core_vnic_attachment as v
where
s.id = v.subnet_id
and v.instance_id = $1;