openstack_aggregateopenstack_application_credentialopenstack_availability_zoneopenstack_compute_imageopenstack_domainopenstack_fipopenstack_groupopenstack_keypairopenstack_networkopenstack_portopenstack_projectopenstack_roleopenstack_role_assignmentopenstack_routeropenstack_security_groupopenstack_security_group_ruleopenstack_serveropenstack_server_groupopenstack_snapshotopenstack_subnetopenstack_useropenstack_volumeopenstack_volume_type
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, namefrom openstack_aggregate;
Aggregate by ID
select availability_zone, hosts, id, namefrom openstack_aggregatewhere id = 1;
All deleted aggregates
select availability_zone, hosts, hosts, metadata, name, created_at, updated_at, deleted_atfrom openstack_aggregatewhere deleted = true;
Aggregates created in the last 90 days
select availability_zone, hosts, id, namefrom openstack_aggregatewhere 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. |