Table: ibm_is_instance_disk - Query IBM Cloud Infrastructure Instance Disks using SQL

IBM Cloud Infrastructure Instance Disks are a component of IBM's cloud computing platform that offer high-performance, reliable, and scalable block storage for virtual server instances. These disks can be used to store data, applications, and the operating system of the instance. They provide persistent, durable storage and can be customized to meet specific workload requirements.

Table Usage Guide

The ibm_is_instance_disk table allows users to gain insights into the disk usage of each IBM Cloud Infrastructure instance. This table is particularly beneficial for system administrators and cloud engineers, providing detailed information on disk configuration, performance, and capacity. It can be used to monitor disk usage patterns, optimize storage allocation, and troubleshoot potential issues related to disk performance.

Examples

Basic info

Discover the segments that highlight the creation time and identifiers of specific instances within IBM's infrastructure service. This is useful for gaining insights into the lifecycle and management of your resources.

select
  name,
  id,
  instance_id,
  created_at
from
  ibm_is_instance_disk;

select
  name,
  id,
  instance_id,
  created_at
from
  ibm_is_instance_disk;

List large disks (> 100 GB)

Explore which IBM instance disks are larger than 100GB. This is useful for managing storage resources and identifying potential areas for data optimization.

select
  name,
  id,
  instance_id,
  created_at
from
  ibm_is_instance_disk
where
  size > 100;

select
  name,
  id,
  instance_id,
  created_at
from
  ibm_is_instance_disk
where
  size > 100;

List unused disks

Determine the areas in which unused disks are present by identifying the disks that are not associated with any running instances. This can help in optimizing resources and managing storage efficiently.

select
  d.name as disk_name,
  d.id as disk_id,
  i.name as instance_name,
  d.created_at
from
  ibm_is_instance_disk as d,
  ibm_is_instance as i
where
  d.instance_id = i.id
  and i.status <> 'running';

select
  d.name as disk_name,
  d.id as disk_id,
  i.name as instance_name,
  d.created_at
from
  ibm_is_instance_disk as d,
  ibm_is_instance as i
where
  d.instance_id = i.id
  and i.status <> 'running';

Query examples

Schema for ibm_is_instance_disk

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The ID fof the account.
created_at	timestamp with time zone		The date and time that the disk was created.
href	text		The URL for this instance disk.
id	text	=	The unique identifier of the instance disk.
instance_id	text	=	The instance identifier.
interface_type	text		The disk interface used for attaching the disk.
name	text		The user defined name for this disk.
region	text		The region of this instance disk.
resource_type	text		The resource type.
size	bigint		The size of the disk in GB (gigabytes).
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.

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_instance_disk