turbot/digitalocean_insights

Query: network_firewall_attached

Usage

powerpipe query digitalocean_insights.query.network_firewall_attached

SQL

select
name as "Droplet Name",
id as "Droplet ID",
created_at as "Create Time",
urn as "URN"
from
digitalocean_droplet
where
id :: text in (
select
d
from
digitalocean_firewall,
jsonb_array_elements_text(droplet_ids) as d
where
urn = $1
)
order by
name;

Dashboards

The query is used in the dashboards: