turbot/steampipe-mod-digitalocean-insights

Dashboard: DigitalOcean Firewall Detail

This dashboard answers the following questions for each firewall:

  • How is the firewall configured?
  • What tags are applied?
  • Which droplets are attached to it?
  • What relationships does the firewall have with other resources?
This dashboard contains 3 cards, 2 flows, 1 graph, 1 input and 3 tables.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-digitalocean-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select DigitalOcean Firewall Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run digitalocean_insights.dashboard.network_firewall_detail --share

Queries

This dashboard uses the the following queries:
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;

Tags