turbot/gcp_insights

Query: compute_instance_firewall_detail

Usage

powerpipe query gcp_insights.query.compute_instance_firewall_detail

SQL

select
f.id::text as "ID",
f.name as "Name",
f.direction as "Direction",
not f.disabled as "Enabled",
f.action as "Action",
f.priority as "Priority"
from
gcp_compute_instance_group g,
gcp_compute_firewall f
where
g.network = f.network
and g.id = (split_part($1, '/', 1))::bigint
and g.project = split_part($1, '/', 2);

Dashboards

The query is used in the dashboards: