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;

Schema for openstack_security_group

Name	Type	Operators	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.