turbot/steampipe-mod-digitalocean-insights

Dashboard: DigitalOcean Block Storage Volume Detail

This dashboard answers the following questions for each volume:

  • How is the volume configured?
  • What tags are applied?
  • Which droplet is it attached to?
  • Which type of filesystem has been configured?
  • What relationships does the volume have with other resources?
This dashboard contains 3 cards, 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 Block Storage Volume Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:
select
d.name as "Droplet Name",
d.id as "Droplet ID",
d.created_at as "Create Time",
d.urn as "Droplet URN",
d.status as "Droplet Status"
from
digitalocean_volume as v,
jsonb_array_elements(v.droplet_ids) as droplet_id,
digitalocean_droplet as d
where
d.id = droplet_id::bigint
and v.urn = $1
order by
d.name;

Tags