steampipe plugin install francois2metz/ovhsteampipe plugin install francois2metz/ovh

ovh_bill ovh_bill_detail ovh_cloud_ai_app ovh_cloud_ai_job ovh_cloud_ai_notebook ovh_cloud_data_job ovh_cloud_database ovh_cloud_flavor ovh_cloud_image ovh_cloud_instance ovh_cloud_postgres ovh_cloud_project ovh_cloud_region ovh_cloud_ssh_key ovh_cloud_storage_s3 ovh_cloud_storage_swift ovh_cloud_volume ovh_cloud_volume_snapshot

Table: ovh_cloud_image

An image is a pre-installed, ready-to-use operating system.

The ovh_cloud_image table can be used to query information about images and you must specify which cloud project in the where or join clause (where project_id=, join ovh_cloud_project on id=).

Examples

List images of a cloud project

select
  id,
  name,
  type
from
  ovh_cloud_image
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'

List public linux images of a cloud project

select
  id,
  name,
  type
from
  ovh_cloud_image
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and visibility = 'public'
  and type = 'linux'

Schema for ovh_cloud_image

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		Image creation date.
flavor_type	text		Image usable only for this type of flavor if not null.
id	text	=	Image ID.
min_disk	bigint		Minimum disks required to use image.
min_ram	bigint		Minimum RAM required to use image.
name	text		Image name.
plan_code	text		Order plan code.
project_id	text	=	Project ID.
region	text		Image region.
size	double precision		Image size (in GiB).
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		Image status.
tags	jsonb		Tags about the image.
type	text		Image type.
user	text		User to connect with.
visibility	text		Image visibility.