Table: openstack_compute_image

An image contains a virtual disk that holds a bootable operating system.

Examples

Basic image info

select
  name,
  status,
  id,
  created,
  min_disk,
  min_ram
from
  openstack_compute_image;

Image by ID

select
  name,
  status,
  id,
  created,
  min_disk,
  min_ram
from
  openstack_compute_image
where
  id = '63a81077-d72f-4429-95b0-897f975af068';

All active images

select
  name,
  id,
  created,
  min_disk,
  min_ram
from
  openstack_compute_image
where
  status = 'ACTIVE';

All images created in the last 30 days

select
  name,
  id,
  created,
  min_disk,
  min_ram
from
  openstack_compute_image
where
  date_part('day', current_date :: timestamp - created :: timestamp) <= 30;

All images not updated in the last 90 days

select
  name,
  id,
  created,
  min_disk,
  min_ram
from
  openstack_compute_image
where
  date_part('day', current_date :: timestamp - updated :: timestamp) >= 90;

All images not yet built

select
  name,
  id,
  created,
  min_disk,
  min_ram
from
  openstack_compute_image
where
  progress < 100;

Schema for openstack_compute_image

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created	timestamp with time zone		Created contain ISO-8601 timestamp of when the image was created.
id	text	=	ID is the unique ID of an image.
metadata	jsonb		Metadata provides free-form key/value pairs that further describe the image.
min_disk	bigint		MinDisk is the minimum amount of disk a flavor must have to be able to create a server based on the image, measured in GB.
min_ram	bigint		MinRAM is the minimum amount of RAM a flavor must have to be able to create a server based on the image, measured in MB.
name	text		Name provides a human-readable moniker for the OS image.
progress	bigint		The Progress and Status fields indicate image-creation status.
status	text		Status is the current status of the image.
updated	timestamp with time zone		Updated contain ISO-8601 timestamp of when the state of the image last changed.