turbot/oci

steampipe plugin install ocisteampipe plugin install oci
oci_apigateway_apioci_autoscaling_auto_scaling_configurationoci_budget_alert_ruleoci_budget_budgetoci_cloud_guard_configurationoci_cloud_guard_detector_recipeoci_cloud_guard_managed_listoci_cloud_guard_responder_recipeoci_cloud_guard_targetoci_core_block_volume_replicaoci_core_boot_volumeoci_core_boot_volume_attachmentoci_core_boot_volume_backupoci_core_boot_volume_metric_read_opsoci_core_boot_volume_metric_read_ops_dailyoci_core_boot_volume_metric_read_ops_hourlyoci_core_boot_volume_metric_write_opsoci_core_boot_volume_metric_write_ops_dailyoci_core_boot_volume_metric_write_ops_hourlyoci_core_dhcp_optionsoci_core_drgoci_core_imageoci_core_instanceoci_core_instance_metric_cpu_utilizationoci_core_instance_metric_cpu_utilization_dailyoci_core_instance_metric_cpu_utilization_hourlyoci_core_internet_gatewayoci_core_local_peering_gatewayoci_core_nat_gatewayoci_core_network_load_balanceroci_core_network_security_groupoci_core_public_ipoci_core_route_tableoci_core_security_listoci_core_service_gatewayoci_core_subnetoci_core_vcnoci_core_volumeoci_core_volume_attachmentoci_core_volume_backupoci_core_volume_backup_policyoci_database_autonomous_databaseoci_dns_rrsetoci_dns_tsig_keyoci_dns_zoneoci_events_ruleoci_file_storage_file_systemoci_file_storage_snapshotoci_functions_applicationoci_identity_api_keyoci_identity_auth_tokenoci_identity_authentication_policyoci_identity_availability_domainoci_identity_compartmentoci_identity_customer_secret_keyoci_identity_dynamic_groupoci_identity_groupoci_identity_network_sourceoci_identity_policyoci_identity_tag_defaultoci_identity_tag_namespaceoci_identity_tenancyoci_identity_useroci_kms_keyoci_kms_key_versionoci_kms_vaultoci_logging_logoci_logging_log_groupoci_mysql_backupoci_mysql_channeloci_mysql_db_systemoci_nosql_tableoci_nosql_table_metric_read_throttle_countoci_nosql_table_metric_read_throttle_count_dailyoci_nosql_table_metric_read_throttle_count_hourlyoci_nosql_table_metric_storage_utilizationoci_nosql_table_metric_storage_utilization_dailyoci_nosql_table_metric_storage_utilization_hourlyoci_nosql_table_metric_write_throttle_countoci_nosql_table_metric_write_throttle_count_dailyoci_nosql_table_metric_write_throttle_count_hourlyoci_objectstorage_bucketoci_ons_notification_topicoci_ons_subscriptionoci_region

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;

.inspect oci_core_volume

OCI Core Volume

NameTypeDescription
auto_tuned_vpus_per_gbbigintThe number of Volume Performance Units per GB that this volume is effectively tuned to when it's idle.
availability_domaintextThe availability domain of the volume.
compartment_idtextColumnDescriptionCompartment
defined_tagsjsonbDefined 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_nametextA user-friendly name.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the volume.
is_auto_tune_enabledbooleanSpecifies whether the auto-tune performance is enabled for this volume.
is_hydratedbooleanSpecifies whether the cloned volume's data has finished copying from the source volume or backup.
kms_key_idtextThe OCID of the Key Management key which is the master encryption key for the volume.
lifecycle_statetextThe current state of a volume.
regiontextThe OCI region in which the resource is located.
size_in_gbsbigintThe size of the volume in GBs.
size_in_mbsbigintThe size of the volume in MBs.
source_detailsjsonbThe volume source, either an existing volume in the same availability domain or a volume backup.
system_tagsjsonbSystem tags to volume by the service.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneThe date and time the volume was created.
titletextTitle of the resource.
volume_group_idtextThe OCID of the source volume group.
vpus_per_gbbigintThe number of volume performance units (VPUs) that will be applied to this volume per GB,representing the Block Volume service's elastic performance options.