Table: ibm_is_security_group - Query IBM Cloud Infrastructure Security Groups using SQL

IBM Cloud Infrastructure Security Groups are a set of IP filter rules that define how to handle inbound and outbound IP traffic to both the virtual server instance and the network interfaces on the virtual server instance. These groups act as a virtual firewall for your virtual server instances to control inbound and outbound traffic. Security groups in a VPC specify which traffic is allowed to or from resources connected to the VPC.

Table Usage Guide

The ibm_is_security_group table provides insights into Security Groups within IBM Cloud Infrastructure. As a network administrator or security analyst, you can explore security group-specific details through this table, including the attached network interfaces, associated rules, and other metadata. Utilize it to uncover information about security groups, such as their configuration, the resources they are protecting, and the rules that govern their behavior.

Examples

Basic info

Explore the basic details of security groups within your IBM cloud infrastructure. This can help you understand the security configurations and rules applied, and identify any potential vulnerabilities or misconfigurations.

select
  id,
  name,
  crn,
  rules,
  targets,
  vpc
from
  ibm_is_security_group;

select
  id,
  name,
  crn,
  rules,
  targets,
  vpc
from
  ibm_is_security_group;

Query examples

Control examples

Schema for ibm_is_security_group

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The ID fof the account.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
created_at	timestamp with time zone		The date and time that the security group was created.
crn	text		The CRN for this security group.
href	text		The URL for this security group.
id	text	=	The unique identifier for this security group.
name	text		The unique user-defined name for this security group.
network_interfaces	jsonb		Array of references to network interfaces.
region	text		The region of this security group.
resource_group	jsonb		The resource group for this security group.
rules	jsonb		Array of rules for this security group. If no rules exist, all traffic will be denied.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
targets	jsonb		Array of references to targets.
title	text		Title of the resource.
vpc	jsonb		The VPC this security group is a part of.

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_is_security_group