turbot/oci_insights

Query: oci_vcn_no_subnet

Usage

powerpipe query oci_insights.query.oci_vcn_no_subnet

SQL

select
case when s.id is null then 'empty' else 'non-empty' end as status,
count(distinct v.id)
from
oci_core_vcn v
left join oci_core_subnet s on s.vcn_id = v.id
where
v.lifecycle_state <> 'TERMINATED'
group by
status;

Dashboards

The query is used in the dashboards: