turbot/digitalocean_insights

Query: droplet_firewall_configuration

Usage

powerpipe query digitalocean_insights.query.droplet_firewall_configuration

SQL

select
f.name as "Name",
f.id as "ID",
f.created_at as "Create Time",
f.urn as "URN"
from
digitalocean_droplet dr,
digitalocean_firewall f,
jsonb_array_elements(droplet_ids) dr_id
where
dr.id = dr_id :: bigint
and dr.urn = $1
order by
f.name;

Dashboards

The query is used in the dashboards: