Table: ibm_account - Query IBM Cloud Accounts using SQL

IBM Cloud Accounts are the foundational entities in IBM Cloud that provide the access to services, resources, and applications within IBM Cloud. They are used to organize resources, manage permissions, and control billing. IBM Cloud Accounts enable users to manage their cloud resources in a secure and efficient manner.

Table Usage Guide

The ibm_account table provides insights into IBM Cloud Accounts. As a cloud administrator or DevOps engineer, explore account-specific details through this table, including account status, owner's identity, and associated metadata. Utilize it to uncover information about accounts, such as their creation time, resource group ID, and the state of the account.

Examples

Basic info

Explore the basic details of your IBM account such as name, status, and owner ID. This can be useful in understanding the current state of your account, and identifying the appropriate owner.

select
  name,
  guid as id,
  state,
  owner_user_id
from
  ibm_account;

select
  name,
  guid as id,
  state,
  owner_user_id
from
  ibm_account;

Get details about account owner

Explore which IBM accounts are linked with their respective owners, allowing you to identify instances where account ownership needs to be updated or verified. This provides useful insights into account management and ensures the correct assignment of resources.

select
  acc.name,
  acc.guid as id,
  acc.state,
  u.first_name || ' ' || u.last_name as owner_full_name
from
  ibm_account as acc,
  ibm_iam_user as u
where
  acc.owner_user_id = u.user_id;

select
  acc.name,
  acc.guid as id,
  acc.state,
  u.first_name || ' ' || u.last_name as owner_full_name
from
  ibm_account as acc,
  ibm_iam_user as u
where
  acc.owner_user_id = u.user_id;

Query examples

Control examples

Schema for ibm_account

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The ID fof the account.
country_code	text		Specifies the country code.
currency_code	text		Specifies the currency type.
customer_id	text		The customer ID of the account.
guid	text		An unique ID of the account.
members	jsonb		A list of members associated with this account.
name	text		Specifies the name of the account.
organizations	jsonb		A list of organizations the account is associated.
owner_guid	text		An unique Id of the account owner.
owner_unique_id	text		An unique identifier of the account owner.
owner_user_id	text		The owner user ID used for login.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		The current state of the account.
type	text		The type of the account.

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_account