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_volume

A volume is an independent additional disk.

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

Examples

List volumes of a cloud project

select
  id,
  name
from
  ovh_cloud_volume
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'

List unused volumes of a cloud project

select
  id,
  name
from
  ovh_cloud_volume
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and status != 'in-use'

Schema for ovh_cloud_volume

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
attached_to	jsonb		Volume attached to instances ID.
bootable	boolean		Volume bootable.
created_at	timestamp with time zone		Volume creation date.
description	text		Volume description.
id	text	=	Volume ID.
name	text		Volume name.
planCode	text		Order plan code.
project_id	text	=	Project ID.
region	text		Volume region.
size	bigint		Volume size (in GB).
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		Volume status.
type	text		Volume type (classic, high-speed, high-speed-gen2