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_instance

An instance is a virtual server in the OVH cloud.

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

Examples

List instances of a cloud project

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

List all instances of all cloud projects

select
  ci.id,
  ci.name
from
  ovh_cloud_instance ci
  join ovh_cloud_project cp on ci.project_id = cp.id

Schema for ovh_cloud_instance

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		Instance creation date.
current_month_outgoing_traffic	bigint		Instance outgoing network traffic for the current month (in bytes).
flavor_id	text		Instance flavor ID.
id	text	=	Instance ID.
image_id	text		Instance image ID.
name	text		Instance name.
plan_code	text		Order plan code.
project_id	text	=	Project ID.
region	text		Region of the instance.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
ssh_key_id	text		Instance ssh key ID.
status	text		Instance status.