Table: openstack_volume

A volume is a virtual disk that holds data. Volumes can be attached to instances.

Examples

Basic volume info

select
  id,
  name,
  description,
  status,
  size,
  availability_zone,
  updated_at,
  created_at,
  attached_at,
  attachment_id,
  device,
  host_name,
  bootable,
  encrypted
from
  openstack_volume;

Volume by ID

select
  id,
  name,
  description,
  status,
  size,
  availability_zone,
  updated_at,
  created_at,
  attached_at,
  attachment_id,
  device,
  host_name,
  bootable,
  encrypted
from
  openstack_volume
where
  id = 'f52d0d12-99b9-4c91-8f21-04b2a5b12a1e';

All bootable volumes bigger than 10 GB

select
  id,
  name,
  description,
  status,
  size,
  availability_zone,
  updated_at,
  created_at,
  attached_at,
  attachment_id,
  device,
  host_name,
  bootable,
  encrypted
from
  openstack_volume
where
  size > 10;

All bootable volumes

select
  id,
  name,
  description,
  status,
  size,
  availability_zone,
  updated_at,
  created_at,
  attached_at,
  attachment_id,
  device,
  host_name,
  bootable,
  encrypted
from
  openstack_volume
where
  bootable = true;

All encrypted volumes

select
  id,
  name,
  description,
  status,
  size,
  availability_zone,
  updated_at,
  created_at,
  attached_at,
  attachment_id,
  device,
  host_name,
  bootable,
  encrypted
from
  openstack_volume
where
  encrypted = true;

Volumes created in the last 30 days

select
  id,
  name,
  description,
  status,
  size,
  availability_zone,
  updated_at,
  created_at,
  attached_at,
  attachment_id,
  device,
  host_name,
  bootable,
  encrypted
from
  openstack_volume
where
  date_part(
    'day',
    current_date :: timestamp - created_at :: timestamp
  ) <= 30;

Volumes not updated in the last 90 days

select
  id,
  name,
  description,
  status,
  size,
  availability_zone,
  updated_at,
  created_at,
  attached_at,
  attachment_id,
  device,
  host_name,
  bootable,
  encrypted
from
  openstack_volume
where
  date_part(
    'day',
    current_date :: timestamp - updated_at :: timestamp
  ) >= 90;

Schema for openstack_volume

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
attached_at	timestamp with time zone		AttachedAt is the time the attachment was created.
attachment_id	text		ID is the Unique identifier for the attachment.
availability_zone	text		AvailabilityZone is which availability zone the volume is in.
backup_id	text		The backup ID, from which the volume was restored. This field is supported since 3.47 microversion.
bootable	boolean		Indicates whether this is a bootable volume.
consistency_group_id	text		ConsistencyGroupID is the consistency group ID.
created_at	timestamp with time zone		The date when this volume was last updated.
description	text		Human-readable description for the volume.
device	text		Name of the attached device.
encrypted	boolean		Encrypted denotes if the volume is encrypted.
host_name	text		Attachment Hostname.
id	text	=	Unique identifier for the volume.
metadata	jsonb		Arbitrary key-value pairs defined by the user.
multiattach	boolean		Multiattach denotes if the volume is multi-attach capable.
name	text		Human-readable display name for the volume.
replication_status	text		ReplicationStatus is the status of replication.
server_id	text		ServerID is the Server UUID associated with this attachment.
size	bigint		Size of the volume in GB.
snapshot_id	text		The ID of the snapshot from which the volume was created.
source_vol_id	text		The ID of another block storage volume from which the current volume was created.
status	text		Current status of the volume.
updated_at	timestamp with time zone		The date when this volume was created.
user_id	text		UserID is the id of the user who created the volume.
volume_image_metadata	jsonb		Image metadata entries, only included for volumes that were created from an image, or from a snapshot of a volume originally created from an image.
volume_type	text		The type of volume to create, either SATA or SSD.