turbot/oci_insights

Query: compute_instances_for_vcn_vcn

Usage

powerpipe query oci_insights.query.compute_instances_for_vcn_vcn

SQL

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