Query: oci_vcn_no_subnet_count

select
  count(*) as value,
  'VCNs Without Subnets' as label,
  case when count(*) = 0 then 'ok' else 'alert' end as type
from
  oci_core_vcn as vcn
where
  vcn.id not in (select oci_core_subnet.vcn_id from oci_core_subnet) and lifecycle_state <> 'TERMINATED';