turbot/gcp_insights

Query: compute_instance_templates_for_compute_subnetwork

Usage

powerpipe query gcp_insights.query.compute_instance_templates_for_compute_subnetwork

SQL

select
t.id :: text as template_id
from
gcp_compute_instance_template t,
jsonb_array_elements(instance_network_interfaces) ni,
gcp_compute_subnetwork s
where
ni ->> 'subnetwork' = s.self_link
and s.id = $1;