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;

Schema for openstack_aggregate

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