turbot/digitalocean_insights

Query: blockstorage_volume_attached_droplets

Usage

powerpipe query digitalocean_insights.query.blockstorage_volume_attached_droplets

SQL

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;

Dashboards

The query is used in the dashboards: