turbot/gcp_insights

Query: compute_subnets_for_compute_instance_group

Usage

powerpipe query gcp_insights.query.compute_subnets_for_compute_instance_group

SQL

select
s.id::text || '/' || s.project as subnetwork_id
from
gcp_compute_instance_group g,
gcp_compute_subnetwork s
where
g.subnetwork = s.self_link
and g.id = (split_part($1, '/', 1))::bigint