turbot/oci

GitHub
steampipe plugin install ocisteampipe plugin install oci
oci_adm_knowledge_baseoci_adm_vulnerability_auditoci_ai_anomaly_detection_ai_private_endpointoci_ai_anomaly_detection_data_assetoci_ai_anomaly_detection_modeloci_ai_anomaly_detection_projectoci_analytics_instanceoci_apigateway_apioci_application_migration_migrationoci_application_migration_sourceoci_artifacts_container_imageoci_artifacts_container_image_signatureoci_artifacts_container_repositoryoci_artifacts_generic_artifactoci_artifacts_repositoryoci_autoscaling_auto_scaling_configurationoci_autoscaling_auto_scaling_policyoci_bastion_bastionoci_bastion_sessionoci_bds_bds_instanceoci_budget_alert_ruleoci_budget_budgetoci_certificates_authority_bundleoci_certificates_management_associationoci_certificates_management_ca_bundleoci_certificates_management_certificateoci_certificates_management_certificate_authorityoci_certificates_management_certificate_authority_versionoci_certificates_management_certificate_versionoci_cloud_guard_configurationoci_cloud_guard_detector_recipeoci_cloud_guard_managed_listoci_cloud_guard_responder_recipeoci_cloud_guard_targetoci_container_instances_containeroci_container_instances_container_instanceoci_containerengine_clusteroci_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_boot_volume_replicaoci_core_cluster_networkoci_core_dhcp_optionsoci_core_drgoci_core_imageoci_core_image_customoci_core_instanceoci_core_instance_configurationoci_core_instance_metric_cpu_utilizationoci_core_instance_metric_cpu_utilization_dailyoci_core_instance_metric_cpu_utilization_hourlyoci_core_internet_gatewayoci_core_load_balanceroci_core_local_peering_gatewayoci_core_nat_gatewayoci_core_network_load_balanceroci_core_network_security_groupoci_core_public_ipoci_core_public_ip_pooloci_core_route_tableoci_core_security_listoci_core_service_gatewayoci_core_subnetoci_core_vcnoci_core_vnic_attachmentoci_core_volumeoci_core_volume_attachmentoci_core_volume_backupoci_core_volume_backup_policyoci_core_volume_default_backup_policyoci_core_volume_groupoci_database_autonomous_databaseoci_database_autonomous_db_metric_cpu_utilizationoci_database_autonomous_db_metric_cpu_utilization_dailyoci_database_autonomous_db_metric_cpu_utilization_hourlyoci_database_autonomous_db_metric_storage_utilizationoci_database_autonomous_db_metric_storage_utilization_dailyoci_database_autonomous_db_metric_storage_utilization_hourlyoci_database_dboci_database_db_homeoci_database_db_systemoci_database_pluggable_databaseoci_database_software_imageoci_devops_projectoci_devops_repositoryoci_dns_rrsetoci_dns_tsig_keyoci_dns_zoneoci_events_ruleoci_file_storage_file_systemoci_file_storage_mount_targetoci_file_storage_snapshotoci_functions_applicationoci_functions_functionoci_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_logging_searchoci_mysql_backupoci_mysql_channeloci_mysql_configurationoci_mysql_configuration_customoci_mysql_db_systemoci_mysql_db_system_metric_connectionsoci_mysql_db_system_metric_connections_dailyoci_mysql_db_system_metric_connections_hourlyoci_mysql_db_system_metric_cpu_utilizationoci_mysql_db_system_metric_cpu_utilization_dailyoci_mysql_db_system_metric_cpu_utilization_hourlyoci_mysql_db_system_metric_memory_utilizationoci_mysql_db_system_metric_memory_utilization_dailyoci_mysql_heat_wave_clusteroci_network_firewall_firewalloci_network_firewall_policyoci_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_objectstorage_objectoci_ons_notification_topicoci_ons_subscriptionoci_queue_queueoci_regionoci_resource_searchoci_resourcemanager_stackoci_streaming_streamoci_vault_secret

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

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
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.
tenant_nametextThe name of the Tenant in which the resource is located.
time_createdtimestamp with time zoneThe date and time the volume was created.
titletextTitle of the resource.
volume_backup_policy_assignment_idtextThe OCID of the volume backup policy assignment.
volume_backup_policy_idtextThe OCID of the volume backup policy that has been assigned to the volume.
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.