turbot/gcp_insights

Query: compute_network_subnet_status

Usage

powerpipe query gcp_insights.query.compute_network_subnet_status

SQL

select
case when s.id is null then 'empty' else 'non-empty' end as status,
count(distinct n.id)
from
gcp_compute_network n
left join gcp_compute_subnetwork s on s.network_name = n.name
group by
status;

Dashboards

The query is used in the dashboards: