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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_id	text		An alpha-numeric value identifying the account ID.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
created_at	timestamp with time zone		The date when the resource group was initially created.
crn	text		The full CRN (cloud resource name) associated with the resource group.
id	text		An alpha-numeric value identifying the resource group.
is_default	boolean	!=, =	Indicates whether this resource group is default of the account or not.
name	text	=	The human-readable name of the resource group.
payment_methods_url	text		The URL to access the payment methods details that associated with the resource group.
quota_id	text		An alpha-numeric value identifying the quota ID associated with the resource group.
quota_url	text		The URL to access the quota details that associated with the resource group.
resource_linkages	text		An array of the resources that linked to the resource group.
state	text		The state of the resource group.
tags	jsonb		A map of tags for the resource.
teams_url	text		The URL to access the team details that associated with the resource group.
title	text		Title of the resource.
updated_at	timestamp with time zone		The 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