turbot/digitalocean_insights

Query: network_firewalls_for_network_vpc

Usage

powerpipe query digitalocean_insights.query.network_firewalls_for_network_vpc

SQL

select
f.urn as firewall_urn
from
digitalocean_firewall as f,
jsonb_array_elements_text(droplet_ids) as did,
digitalocean_droplet as d,
digitalocean_vpc as v
where
d.vpc_uuid = v.id
and did = d.id::text
and v.urn = $1;