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';