turbot/gcp_insights

Query: compute_networks_for_compute_instance

Usage

powerpipe query gcp_insights.query.compute_networks_for_compute_instance

SQL

select
n.id :: text as network_id
from
gcp_compute_instance i,
gcp_compute_network n,
jsonb_array_elements(network_interfaces) as ni
where
ni ->> 'network' = n.self_link
and i.id = $1;