turbot/digitalocean_insights

Query: blockstorage_volume_droplet_attached_count

Usage

powerpipe query digitalocean_insights.query.blockstorage_volume_droplet_attached_count

Steampipe Tables

SQL

select
count(*) as value,
'Not In-Use' as label,
case
count(*)
when 0 then 'ok'
else 'alert'
end as "type"
from
digitalocean_volume
where
jsonb_array_length(droplet_ids) = 0;

Dashboards

The query is used in the dashboards: