Table: ibm_kms_key_ring - Query IBM Key Protect Key Rings using SQL

IBM Key Protect is a cloud-based service designed to manage and protect cryptographic keys used in IBM cloud services. It provides a secure way to generate, manage, and destroy encryption keys, which are used to protect data-at-rest in IBM cloud services. Key Rings in IBM Key Protect are used to organize keys and control access to them.

Table Usage Guide

The ibm_kms_key_ring table provides insights into Key Rings within IBM Key Protect. As a security engineer, explore key ring-specific details through this table, including key ring ID, name, and creation date. Utilize it to manage and monitor your cryptographic keys, ensuring secure access to your IBM cloud services.

Examples

Basic info

Explore the creation dates and titles of key rings within a specific instance in IBM's Key Management Service. This can be beneficial in understanding the organization and timeline of your security infrastructure.

select
  title,
  instance_id,
  creation_date
from
  ibm_kms_key_ring
where
  instance_id = '148be70a-ee65-4149-8222-1bf0ff45542f';

select
  title,
  instance_id,
  creation_date
from
  ibm_kms_key_ring
where
  instance_id = '148be70a-ee65-4149-8222-1bf0ff45542f';

Schema for ibm_kms_key_ring

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The ID fof the account.
created_by	text		The creator of the key ring.
creation_date	timestamp with time zone		The date and time when the key ring was created.
id	text		An unique identifier of the key ring.
instance_id	text	=	The key protect instance GUID.
region	text		The region of this key ring.
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_kms_key_ring