turbot/oci_insights

Query: vcn_vcns_for_database_autonomous_database

Usage

powerpipe query oci_insights.query.vcn_vcns_for_database_autonomous_database

SQL

select
s.vcn_id as vcn_id
from
oci_database_autonomous_database as d
left join oci_core_subnet as s on s.id = d.subnet_id
where
d.subnet_id is not null
and d.id = $1;