steampipe plugin install ibm

Table: ibm_resource_group - Query IBM Resource Group using SQL

An IBM Resource Group is a way to manage and organize resources in an IBM Cloud account. It allows users to manage access to resources, assign resources to different teams, and track costs. Resource Groups are similar to tags, but they provide a higher level of organization and control.

Table Usage Guide

The ibm_resource_group table provides insights into Resource Groups within IBM Cloud. As a cloud administrator, you can explore group-specific details through this table, including the group's ID, name, state, and more. Utilize it to manage and organize your resources effectively, assign resources to different teams, and track costs.

Examples

Basic info

Explore the status and creation date of various resources within your IBM account. This can be useful for understanding the distribution and organization of resources, as well as identifying any potential issues or anomalies.

select
name,
id,
crn,
state,
created_at,
account_id
from
ibm_resource_group;
select
name,
id,
crn,
state,
created_at,
account_id
from
ibm_resource_group;

List default resource groups

Explore which resource groups have been set as default in your IBM cloud setup. This can help streamline resource management and optimize cloud operations.

select
name,
id,
crn,
state,
created_at
from
ibm_resource_group
where
is_default;
select
name,
id,
crn,
state,
created_at
from
ibm_resource_group
where
is_default = 1;

List resource groups by name

This query helps you pinpoint specific resource groups in your IBM account by their name. This can be particularly useful in managing resources and understanding their allocation within your infrastructure.

select
name,
id,
crn,
state,
created_at,
account_id
from
ibm_resource_group
where
name = 'Default';
select
name,
id,
crn,
state,
created_at,
account_id
from
ibm_resource_group
where
name = 'Default';

Schema for ibm_resource_group

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextAn alpha-numeric value identifying the account ID.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
created_attimestamp with time zoneThe date when the resource group was initially created.
crntextThe full CRN (cloud resource name) associated with the resource group.
idtextAn alpha-numeric value identifying the resource group.
is_defaultboolean!=, =Indicates whether this resource group is default of the account or not.
nametext=The human-readable name of the resource group.
payment_methods_urltextThe URL to access the payment methods details that associated with the resource group.
quota_idtextAn alpha-numeric value identifying the quota ID associated with the resource group.
quota_urltextThe URL to access the quota details that associated with the resource group.
resource_linkagestextAn array of the resources that linked to the resource group.
statetextThe state of the resource group.
tagsjsonbA map of tags for the resource.
teams_urltextThe URL to access the team details that associated with the resource group.
titletextTitle of the resource.
updated_attimestamp with time zoneThe date when the resource group was last updated.

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_resource_group