Query: network_firewall_rules_count

select
  'Firewall Rules' as label,
  count(f.*) as value,
  case
    when count(f.*) > 0 then 'ok'
    else 'alert'
  end as type
from
  gcp_compute_firewall f,
  gcp_compute_network n
where
  split_part(f.network, 'networks/', 2) = n.name
  and f.project = n.project
  and n.id = $1;