Query: vpc_no_vswitch_count

select
   count(*) as value,
   'VPCs Without vSwitches' as label,
   case when count(*) = 0 then 'ok' else 'alert' end as type
  from
    alicloud_vpc as vpc
    left join alicloud_vpc_vswitch as s on vpc.vpc_id = s.vpc_id
  where
    s.vswitch_id is null;