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

Schema for ibm_account

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
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