steampipe plugin install awssteampipe plugin install aws

Table: aws_ebs_volume

An Amazon EBS volume is a durable, block-level storage device that you can attach to your instances.

Examples

List of unencrypted EBS volumes

select
  volume_id,
  encrypted
from
  aws_ebs_volume
where
  not encrypted;

List of unattached EBS volumes

select
  volume_id,
  volume_type
from
  aws_ebs_volume
where
  jsonb_array_length(attachments) = 0;

List of Provisioned IOPS SSD (io1) volumes

select
  volume_id,
  volume_type
from
  aws_ebs_volume
where
  volume_type = 'io1';

List of EBS volumes with size more than 100GiB

select
  volume_id,
  size
from
  aws_ebs_volume
where
  size > '100';

Count the number of EBS volumes by volume type

select
  volume_type,
  count(volume_type) as count
from
  aws_ebs_volume
group by
  volume_type;

Find EBS Volumes Attached To Stopped EC2 Instances

select
  volume_id,
  size,
  att ->> 'InstanceId' as instance_id
from
  aws_ebs_volume
  cross join jsonb_array_elements(attachments) as att
  join aws_ec2_instance as i on i.instance_id = att ->> 'InstanceId'
where
  instance_state = 'stopped';

Query examples

Control examples

.inspect aws_ebs_volume

AWS EBS Volume

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
arn	text	The Amazon Resource Name (ARN) specifying the volume.
attachments	jsonb	Information about the volume attachments.
auto_enable_io	boolean	The state of autoEnableIO attribute.
availability_zone	text	The Availability Zone for the volume.
create_time	timestamp with time zone	The time stamp when volume creation was initiated.
encrypted	boolean	Indicates whether the volume is encrypted.
fast_restored	boolean	Indicates whether the volume was created using fast snapshot restore.
iops	bigint	The number of I/O operations per second (IOPS) that the volume supports.
kms_key_id	text	The Amazon Resource Name (ARN) of the AWS Key Management Service (AWS KMS) customer master key (CMK) that was used to protect the volume encryption key for the volume.
multi_attach_enabled	boolean	Indicates whether Amazon EBS Multi-Attach is enabled.
outpost_arn	text	The Amazon Resource Name (ARN) of the Outpost.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
product_codes	jsonb	A list of product codes.
region	text	The AWS Region in which the resource is located.
size	bigint	The size of the volume, in GiBs.
snapshot_id	text	The snapshot from which the volume was created, if applicable.
state	text	The volume state.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags assigned to the volume.
title	text	Title of the resource.
volume_id	text	The ID of the volume.
volume_type	text	The volume type. This can be gp2 for General Purpose SSD, io1 or io2 for Provisioned IOPS SSD, st1 for Throughput Optimized HDD, sc1 for Cold HDD, or standard for Magnetic volumes.

turbot/aws

Table: aws_ebs_volume

Examples

List of unencrypted EBS volumes

List of unattached EBS volumes

List of Provisioned IOPS SSD (io1) volumes

List of EBS volumes with size more than 100GiB

Count the number of EBS volumes by volume type

Find EBS Volumes Attached To Stopped EC2 Instances

Query examples

Control examples

.inspect aws_ebs_volume

Steampipe

Resources

Community