steampipe plugin install ernw/openstacksteampipe plugin install ernw/openstack

Table: openstack_security_group

A security group is a container of security group rules. A default security group is assigned to newly created instances.

Examples

Basic security group info

select
  name,
  description,
  rules,
  id,
  project_id,
  updated_at,
  created_at
from
  openstack_security_group;

Security group by ID

select
  name,
  description,
  rules,
  id,
  project_id,
  updated_at,
  created_at
from
  openstack_security_group
where
  id = 'b29d3c6b-1d21-4094-8d75-1fc0dac7f1af';

All security groups created in the last 30 days

select
  name,
  description,
  rules,
  id,
  project_id,
  updated_at,
  created_at
from
  openstack_security_group
where
  date_part(
    'day',
    current_date :: timestamp - created_at :: timestamp
  ) <= 30;

All security groups that have been updated

select
  name,
  description,
  rules,
  id,
  project_id,
  updated_at,
  created_at
from
  openstack_security_group
where
  updated_at != created_at;

.inspect openstack_security_group

Table of all security groups.

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone	CreatedAt contains an ISO-8601 timestamp of when the security group was created.
description	text	The security group description.
id	text	The UUID for the security group.
name	text	Human-readable name for the security group. Might not be unique.
project_id	text	ProjectID is the project owner of the security group.
rules	text	A slice of security group rules that dictate the permitted behaviour for traffic entering and leaving the group.
tags	text	Tags optionally set via extensions/attributestags.
tenant_id	text	TenantID is the project owner of the security group.
updated_at	timestamp with time zone	UpdatedAt contains an ISO-8601 timestamp of when the state of the security group last changed.

ernw/openstack