ernw/openstack

GitHub
steampipe plugin install ernw/openstacksteampipe plugin install ernw/openstack

Table: openstack_aggregate

A host aggregate partitions the hypervisor hosts in an OpenStack cloud. This can be used to partition the hypervisors, e.g., depending on their hardware capabilities.

Examples

Basic aggregate info

select
availability_zone,
hosts,
id,
name
from
openstack_aggregate;

Aggregate by ID

select
availability_zone,
hosts,
id,
name
from
openstack_aggregate
where
id = 1;

All deleted aggregates

select
availability_zone,
hosts,
hosts,
metadata,
name,
created_at,
updated_at,
deleted_at
from
openstack_aggregate
where
deleted = true;

Aggregates created in the last 90 days

select
availability_zone,
hosts,
id,
name
from
openstack_aggregate
where
date_part(
'day',
current_date :: timestamp - created_at :: timestamp
) <= 90;

.inspect openstack_aggregate

Table of all host aggregates.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
availability_zonetextThe availability zone of the host aggregate.
created_attimestamp with time zoneThe date and time when the resource was created.
deletedbooleanDeleted indicates whether this aggregate is deleted or not.
deleted_attimestamp with time zoneThe date and time when the resource was deleted.
hostsjsonbA list of host ids in this aggregate.
idbigintThe ID of the host aggregate.
metadatajsonbMetadata key and value pairs associate with the aggregate.
nametextName of the aggregate.
updated_attimestamp with time zoneThe date and time when the resource was updated.