turbot/digitalocean_insights

Query: network_vpcs_for_network_firewall

Usage

powerpipe query digitalocean_insights.query.network_vpcs_for_network_firewall

SQL

select
v.urn as vpc_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 f.urn = $1;