turbot/aws_thrifty

Control: Are there any unattached EBS volumes?

Description

Unattached EBS volumes render little usage, are expensive to maintain and should be reviewed.

Usage

Run the control in your terminal:

powerpipe control run aws_thrifty.control.unattached_ebs_volumes

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_thrifty.control.unattached_ebs_volumes --share

Steampipe Tables

SQL

select
arn as resource,
case
when jsonb_array_length(attachments) > 0 then 'ok'
else 'alarm'
end as status,
case
when jsonb_array_length(attachments) > 0 then volume_id || ' has attachments.'
else volume_id || ' has no attachments.'
end as reason
, region, account_id
from
aws_ebs_volume;

Tags