turbot/gcp_insights

Query: compute_firewalls_for_compute_instance

Usage

powerpipe query gcp_insights.query.compute_firewalls_for_compute_instance

SQL

select
f.id :: text as firewall_id
from
gcp_compute_instance i,
gcp_compute_firewall f,
jsonb_array_elements(network_interfaces) as ni
where
ni ->> 'network' = f.network
and i.id = $1;