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.

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
availability_zone	text	The availability zone of the host aggregate.
created_at	timestamp with time zone	The date and time when the resource was created.
deleted	boolean	Deleted indicates whether this aggregate is deleted or not.
deleted_at	timestamp with time zone	The date and time when the resource was deleted.
hosts	jsonb	A list of host ids in this aggregate.
id	bigint	The ID of the host aggregate.
metadata	jsonb	Metadata key and value pairs associate with the aggregate.
name	text	Name of the aggregate.
updated_at	timestamp with time zone	The date and time when the resource was updated.

ernw/openstack