turbot/gcp_insights

Query: compute_instance_group_network_detail

Usage

powerpipe query gcp_insights.query.compute_instance_group_network_detail

SQL

select
n.name as "Network",
s.name as "Subnetwork",
s.gateway_address as "Subnet Gateway",
s.ip_cidr_range::text as "IP CIDR Range"
from
gcp_compute_instance_group g,
gcp_compute_network n,
gcp_compute_subnetwork s
where
g.network = n.self_link
and g.subnetwork = s.self_link
and g.id = (split_part($1, '/', 1))::bigint
and g.project = split_part($1, '/', 2);

Dashboards

The query is used in the dashboards: