v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins

francois2metz/ovh

steampipe plugin install francois2metz/ovhsteampipe plugin install francois2metz/ovh

Table: ovh_cloud_region

Regions available for a cloud project.

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

Examples

List regions of a cloud project

select
  name,
  type,
  status
from
  ovh_cloud_region
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'

List regions not UP

select
  name
from
  ovh_cloud_postgres
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and status != 'UP'

Get specific region

select
  name,
  type,
  status
from
  ovh_cloud_region
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and name = 'GRA'

Schema for ovh_cloud_region

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
continent_code	text		Region continent code.
datacenter_location	text		Location of the datacenter where the region is.
ip_countries	jsonb		Allowed countries for failover ip.
name	text	=	Name of the region.
project_id	text	=	Project ID.
services	jsonb		Details about components status.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		OpenStack region status.
type	text		Region type.