Table: alicloud_ecs_disk

Cloud disks are block-level Elastic Block Storage (EBS) products provided by Alibaba Cloud for ECS and provide low latency, high performance, high durability, and high reliability. Cloud disks use a distributed triplicate mechanism to ensure data durability for ECS instances. If service disruptions occur within a zone (for example, due to hardware failures), data within the zone is copied to an available disk in another zone to help ensure data availability.

Examples

Basic info

select
  name,
  disk_id,
  arn,
  size,
  type,
  billing_method,
  zone,
  region
from
  alicloud_ecs_disk;

Unencrypted Disks

select
  name,
  disk_id,
  encrypted,
  zone,
  status,
  size,
  instance_id,
  kms_key_id
from
  alicloud_ecs_disk
where
  not encrypted;

List of disks Encrypted with Default Service CMK

select
  name,
  disk_id,
  encrypted,
  zone,
  status,
  size,
  instance_id,
  kms_key_id
from
  alicloud_ecs_disk
where
  encrypted
  and kms_key_id = '';

List Auto Snapshot Policy details applied to disk

select
  name,
  auto_snapshot_policy_id,
  auto_snapshot_policy_name,
  auto_snapshot_policy_creation_time,
  auto_snapshot_policy_enable_cross_region_copy,
  auto_snapshot_policy_repeat_week_days,
  auto_snapshot_policy_retention_days,
  auto_snapshot_policy_status,
  auto_snapshot_policy_time_points,
  auto_snapshot_policy_tags
from
  alicloud_ecs_disk;

List of disks without owner tag key

select
  name,
  disk_id,
  tags
from
  alicloud_ecs_disk
where
  tags ->> 'owner' is null;

List disks attached to a specific instance

select
  name,
  disk_id,
  size,
  type,
  billing_method,
  zone,
  region,
  encrypted
from
  alicloud_ecs_disk
where
  instance_id = 'i-0xickpvpsaih9w7s4zrq';

List of disks not attached to any instances

select
  name,
  disk_id,
  status,
  attached_time,
  detached_time
from
  alicloud_ecs_disk
where
  status = 'Available';

Disk count in each availability zone

select
  zone,
  count(*)
from
  alicloud_ecs_disk
group by
  zone
order by
  count desc;

Top 10 largest Disks

select
  name,
  disk_id,
  size,
  status,
  instance_id
from
  alicloud_ecs_disk
order by
  size desc
limit
  10;

List of disks having no attached running instances

select
  i.instance_id as "Instance ID",
  i.name as "Name",
  i.arn as "Instance ARN",
  i.status as "Instance State",
  attachment ->> 'AttachedTime' as "Attachment Time"
from
  alicloud_ecs_disk as v,
  jsonb_array_elements(attachments) as attachment,
  alicloud_ecs_instance as i
where
  i.instance_id = attachment ->> 'InstanceId'
  and i.status <> 'Running'
order by
  i.instance_id;

Query examples

Control examples

.inspect alicloud_ecs_disk

Elastic Compute Disk

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The Alicloud 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 Alibaba Cloud Resource Name (ARN) of the ECS disk.
attached_time	timestamp with time zone	The time when the disk was attached.
attachments	jsonb	The attachment information of the cloud disk.
auto_snapshot_policy_creation_time	text	The time when the auto snapshot policy was created.
auto_snapshot_policy_enable_cross_region_copy	boolean	The ID of the automatic snapshot policy applied to the disk.
auto_snapshot_policy_id	text	The ID of the automatic snapshot policy applied to the disk.
auto_snapshot_policy_name	text	The name of the automatic snapshot policy applied to the disk.
auto_snapshot_policy_repeat_week_days	text	The days of a week on which automatic snapshots are created. Valid values: 1 to 7, which corresponds to the days of the week. 1 indicates Monday. One or more days can be specified.
auto_snapshot_policy_retention_days	bigint	The retention period of the automatic snapshot.
auto_snapshot_policy_status	text	The status of the automatic snapshot policy.
auto_snapshot_policy_tags	jsonb	The days of a week on which automatic snapshots are created. Valid values: 1 to 7, which corresponds to the days of the week. 1 indicates Monday. One or more days can be specified.
auto_snapshot_policy_time_points	text	The points in time at which automatic snapshots are created. The least interval at which snapshots can be created is one hour. Valid values: 0 to 23, which corresponds to the hours of the day from 00:00 to 23:00. 1 indicates 01:00. You can specify multiple points in time.
billing_method	text	The billing method of the disk. Possible values are: PrePaid and PostPaid.
category	text	The category of the disk.
creation_time	timestamp with time zone	The time when the disk was created.
delete_auto_snapshot	boolean	Indicates whether the automatic snapshots of the disk are deleted when the disk is released.
delete_with_instance	boolean	Indicates whether the disk is released when its associated instance is released.
description	text	A user provided, human readable description for this resource.
detached_time	timestamp with time zone	The time when the disk was detached.
device	text	The device name of the disk on its associated instance.
disk_id	text	An unique identifier for the resource.
enable_auto_snapshot	boolean	Indicates whether the automatic snapshot policy feature was enabled for the disk.
enable_automated_snapshot_policy	boolean	Indicates whether an automatic snapshot policy was applied to the disk.
encrypted	boolean	Indicates whether the disk was encrypted.
expired_time	timestamp with time zone	The time when the subscription disk expires.
image_id	text	The ID of the image used to create the instance. This parameter is empty unless the disk was created from an image. The value of this parameter remains unchanged throughout the lifecycle of the disk.
instance_id	text	The ID of the instance to which the disk is attached. This parameter has a value only when the value of Status is In_use.
iops	bigint	The number of input/output operations per second (IOPS).
iops_read	bigint	The number of I/O reads per second.
iops_write	bigint	The number of I/O writes per second.
kms_key_id	text	The device name of the disk on its associated instance.
mount_instance_num	bigint	The number of instances to which the Shared Block Storage device is attached.
mount_instances	jsonb	The attaching information of the disk.
name	text	A friendly name for the resource.
operation_lock	jsonb	The reasons why the disk was locked.
performance_level	text	The performance level of the ESSD.
portable	boolean	Indicates whether the disk is removable.
product_code	text	The product code in Alibaba Cloud Marketplace.
region	text	The Alicloud region in which the resource is located.
resource_group_id	text	The ID of the resource group to which the disk belongs.
serial_number	text	The serial number of the disk.
size	bigint	Specifies the size of the disk.
source_snapshot_id	text	The ID of the snapshot used to create the disk. This parameter is empty unless the disk was created from a snapshot. The value of this parameter remains unchanged throughout the lifecycle of the disk.
status	text	Specifies the current state of the resource.
storage_set_id	text	The ID of the storage set.
storage_set_partition_number	bigint	The maximum number of partitions in a storage set.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags attached with the resource.
title	text	Title of the resource.
type	text	Specifies the type of the disk. Possible values are: 'system' and 'data'.
zone	text	The zone name in which the resource is created.

turbot/alicloud