turbot/steampipe-mod-digitalocean-insights

Dashboard: DigitalOcean Droplet Detail

This dashboard answers the following questions for each droplet:

  • How is the droplet configured?
  • What tags are applied?
  • Which volumes are attached to it?
  • Which firewalls and VPC is it associated with?
  • What relationships does the droplet have with other resources?
This dashboard contains 6 cards, 1 graph, 1 input and 5 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 Droplet Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select
v.name as "Name",
v.id as "ID",
v.created_at as "Create Time",
v.urn as "URN"
from
digitalocean_droplet as d,
jsonb_array_elements_text(d.volume_ids) as volume_id,
digitalocean_volume as v
where
v.id = volume_id
and d.urn = $1
order by
v.name;

Tags