ernw/openstack

GitHub
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.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zoneCreatedAt contains an ISO-8601 timestamp of when the security group was created.
descriptiontextThe security group description.
idtextThe UUID for the security group.
nametextHuman-readable name for the security group. Might not be unique.
project_idtextProjectID is the project owner of the security group.
rulestextA slice of security group rules that dictate the permitted behaviour for traffic entering and leaving the group.
tagstextTags optionally set via extensions/attributestags.
tenant_idtextTenantID is the project owner of the security group.
updated_attimestamp with time zoneUpdatedAt contains an ISO-8601 timestamp of when the state of the security group last changed.