steampipe plugin install ibm

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;

Schema for ibm_is_volume

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe account ID of this volume.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
capacitybigintThe capacity of the volume in gigabytes.
created_attimestamp with time zoneThe date and time that the volume was created.
crntextThe CRN for this volume.
encryptiontextThe type of encryption used on the volume.
encryption_keytextA 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`.
hreftextThe URL for this volume.
idtext=The unique identifier for this volume.
iopsbigintThe bandwidth for the volume.
nametext=The user-defined name for this volume.
profilejsonbThe profile for this volume.
regiontextThe region of this volume.
resource_groupjsonbThe resource group for this volume.
statustextThe status of the volume.
status_reasonsjsonbThe enumerated reason code values for this property will expand in the future.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
volume_attachmentsjsonbThe collection of volume attachments attaching instances to the volume..
zonejsonbThe 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