Table: ibm_is_volume - Query IBM Cloud Infrastructure Volumes using SQL

IBM Cloud Infrastructure Volumes is a block storage service that provides scalable and reliable storage for your virtual server instances. It offers a variety of volume types that are optimized for different types of workloads, including transactional and big data workloads. IBM Cloud Infrastructure Volumes ensures data availability and durability by automatically replicating data across multiple physical drives.

Table Usage Guide

The ibm_is_volume table provides insights into volumes within IBM Cloud Infrastructure. As a system administrator, explore volume-specific details through this table, including size, profile, and status. Utilize it to uncover information about volumes, such as those with specific profiles, the capacity of the volumes, and the status of the volumes.

Examples

Basic info

Explore the status and creation date of various resources in your IBM Cloud infrastructure. This allows you to monitor the health and lifecycle of your resources effectively.

select
  name,
  id,
  crn,
  status,
  created_at
from
  ibm_is_volume;

select
  name,
  id,
  crn,
  status,
  created_at
from
  ibm_is_volume;

List volumes by name

Determine the status and creation date of a specific volume in an IBM cloud infrastructure. This can be useful for tracking the lifecycle of your resources and managing their use effectively.

select
  name,
  id,
  crn,
  status,
  created_at
from
  ibm_is_volume
where
  name = 'steampipe01';

select
  name,
  id,
  crn,
  status,
  created_at
from
  ibm_is_volume
where
  name = 'steampipe01';

List of volumes with size more than 100GB

Analyze the settings to understand which storage volumes exceed a capacity of 100GB. This can be useful for managing storage resources and identifying potential areas for data optimization.

select
  name,
  id,
  crn,
  capacity
from
  ibm_is_volume
where
  capacity > 100;

select
  name,
  id,
  crn,
  capacity
from
  ibm_is_volume
where
  capacity > 100;

List volumes not encrypted using user-managed key

Explore which storage volumes are not using user-managed encryption. This can help assess the security measures in place and identify potential areas for improvement.

select
  name,
  id,
  crn,
  encryption,
  encryption_key
from
  ibm_is_volume
where
  encryption <> 'user_managed';

select
  name,
  id,
  crn,
  encryption,
  encryption_key
from
  ibm_is_volume
where
  encryption <> 'user_managed';

Volume count in each availability zone

Explore which availability zones have the most volumes to better manage and distribute your resources. This could be particularly useful in balancing workloads and optimizing performance across different zones.

select
  zone ->> 'name' as zone_name,
  count(*)
from
  ibm_is_volume
group by
  zone_name;

select
  json_extract(zone, '$.name') as zone_name,
  count(*)
from
  ibm_is_volume
group by
  zone_name;

Query examples

Schema for ibm_is_volume

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_id	text		The account ID of this volume.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
capacity	bigint		The capacity of the volume in gigabytes.
created_at	timestamp with time zone		The date and time that the volume was created.
crn	text		The CRN for this volume.
encryption	text		The type of encryption used on the volume.
encryption_key	text		A reference to the root key used to wrap the data encryption key for the volume. This property will be present for volumes with an `encryption` type of `user_managed`.
href	text		The URL for this volume.
id	text	=	The unique identifier for this volume.
iops	bigint		The bandwidth for the volume.
name	text	=	The user-defined name for this volume.
profile	jsonb		The profile for this volume.
region	text		The region of this volume.
resource_group	jsonb		The resource group for this volume.
status	text		The status of the volume.
status_reasons	jsonb		The enumerated reason code values for this property will expand in the future.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
volume_attachments	jsonb		The collection of volume attachments attaching instances to the volume..
zone	jsonb		The zone this volume resides in.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- ibm

You can pass the configuration to the command with the --config argument:

steampipe_export_ibm --config '<your_config>' ibm_is_volume