Query: compute_network_no_subnet_count

select
   count(*) as value,
   'Networks Without Subnets' as label,
   case when count(*) = 0 then 'ok' else 'alert' end as type
  from
    gcp_compute_network as n
    left join gcp_compute_subnetwork as s on n.name = s.network_name
  where
    s.id is null;