steampipe plugin install ibmsteampipe plugin install ibm

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
country_codetextSpecifies the country code.
currency_codetextSpecifies the currency type.
customer_idtextThe customer ID of the account.
guidtextAn unique ID of the account.
membersjsonbA list of members associated with this account.
nametextSpecifies the name of the account.
organizationsjsonbA list of organizations the account is associated.
owner_guidtextAn unique Id of the account owner.
owner_unique_idtextAn unique identifier of the account owner.
owner_user_idtextThe owner user ID used for login.
statetextThe current state of the account.
typetextThe 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