Table: oci_core_volume

The Oracle Cloud Infrastructure Block Volume service lets you dynamically provision and manage block storage volume.

Examples

Basic info

select
  id as volume_id,
  display_name,
  lifecycle_state,
  time_created
from
  oci_core_volume;

List volumes with a faulty state

select
  id as volume_id,
  display_name,
  lifecycle_state,
  time_created
from
  oci_core_volume
where
  lifecycle_state = 'FAULTY';

List volumes with size greater than 1024 GB

select
  id as volume_id,
  display_name,
  lifecycle_state,
  size_in_gbs
from
  oci_core_volume
where
  size_in_gbs > 1024;

List volumes with Oracle managed encryption (volumes are encrypted by default with Oracled managed encryption keys)

select
  id as volume_id,
  display_name,
  lifecycle_state,
  time_created
from
  oci_core_volume
where
  kms_key_id is null;

List volumes with customer managed encryption

select
  id as volume_id,
  display_name,
  lifecycle_state,
  time_created
from
  oci_core_volume
where
  kms_key_id is not null;

List volumes created in the root compartment

select
  id as volume_id,
  display_name,
  lifecycle_state,
  tenant_id,
  compartment_id
from
  oci_core_volume
where
  compartment_id = tenant_id;

Query examples

Control examples

.inspect oci_core_volume

OCI Core Volume

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
auto_tuned_vpus_per_gb	bigint	The number of Volume Performance Units per GB that this volume is effectively tuned to when it's idle.
availability_domain	text	The availability domain of the volume.
compartment_id	text	ColumnDescriptionCompartment
defined_tags	jsonb	Defined tags for resource. Defined tags are set up in your tenancy by an administrator. Only users granted permission to work with the defined tags can apply them to resources.
display_name	text	A user-friendly name.
freeform_tags	jsonb	Free-form tags for resource. This tags can be applied by any user with permissions on the resource.
id	text	The OCID of the volume.
is_auto_tune_enabled	boolean	Specifies whether the auto-tune performance is enabled for this volume.
is_hydrated	boolean	Specifies whether the cloned volume's data has finished copying from the source volume or backup.
kms_key_id	text	The OCID of the Key Management key which is the master encryption key for the volume.
lifecycle_state	text	The current state of a volume.
region	text	The OCI region in which the resource is located.
size_in_gbs	bigint	The size of the volume in GBs.
size_in_mbs	bigint	The size of the volume in MBs.
source_details	jsonb	The volume source, either an existing volume in the same availability domain or a volume backup.
system_tags	jsonb	System tags to volume by the service.
tags	jsonb	A map of tags for the resource.
tenant_id	text	The OCID of the Tenant in which the resource is located.
tenant_name	text	The name of the Tenant in which the resource is located.
time_created	timestamp with time zone	The date and time the volume was created.
title	text	Title of the resource.
volume_backup_policy_assignment_id	text	The OCID of the volume backup policy assignment.
volume_backup_policy_id	text	The OCID of the volume backup policy that has been assigned to the volume.
volume_group_id	text	The OCID of the source volume group.
vpus_per_gb	bigint	The number of volume performance units (VPUs) that will be applied to this volume per GB,representing the Block Volume service's elastic performance options.

turbot/oci

Table: oci_core_volume

Examples

Basic info

List volumes with a faulty state

List volumes with size greater than 1024 GB

List volumes with Oracle managed encryption (volumes are encrypted by default with Oracled managed encryption keys)

List volumes with customer managed encryption

List volumes created in the root compartment

Query examples

Control examples

.inspect oci_core_volume

Steampipe

Resources

Community