Control: Large block storage volumes are unusual, expensive and should be reviewed.
Description
Block storage volumes with over 100 GB should be resized if too large
Usage
Run the control in your terminal:
powerpipe control run digitalocean_thrifty.control.block_storage_volume_largeSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run digitalocean_thrifty.control.block_storage_volume_large --shareSteampipe Tables
Params
| Args | Name | Default | Description | Variable |
|---|---|---|---|---|
| $1 | block_storage_volume_max_size_gb | | The maximum size (GB) allowed for volumes. |
SQL
select v.urn as resource, case when v.size_gigabytes <= $1 then 'ok' else 'alarm' end as status, v.id || ' is ' || v.size_gigabytes || 'GB.' as reason , r.name as region from digitalocean_volume as v left join digitalocean_region as r on r.slug = v.region_slug;