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_attachment

You can attach a volume to an instance in order to expand the available storage on the instance. If you specify iSCSI as the volume attachment type, you must also connect and mount the volume from the instance for the volume to be usable.

Examples

Basic info

select
id,
display_name,
lifecycle_state,
time_created
from
oci_core_volume_attachment;

List idle volume attachments

select
id,
display_name,
lifecycle_state,
time_created
from
oci_core_volume_attachment
where
lifecycle_state <> 'ATTACHED';

List read only volume attachments

select
id,
display_name,
lifecycle_state,
time_created
from
oci_core_volume_attachment
where
is_read_only;

.inspect oci_core_volume_attachment

OCI Core Volume Attachment

NameTypeDescription
availability_domaintextThe availability domain of an instance.
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
devicetextThe device name.
display_nametextA user-friendly name. Does not have to be unique, and it cannot be changed.
idtextThe OCID of the volume attachment.
instance_idtextThe OCID of the instance the volume is attached to.
is_multipathbooleanWhether the attachment is multipath or not.
is_pv_encryption_in_transit_enabledbooleanWhether in-transit encryption for the data volume's paravirtualized attachment is enabled or not.
is_read_onlybooleanWhether the attachment was created in read-only mode.
is_shareablebooleanWhether the attachment should be created in shareable mode.
iscsi_login_statetextThe iscsi login state of the volume attachment.
lifecycle_statetextThe current state of the volume attachment.
regiontextThe OCI region in which the resource is located.
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_idtextThe OCID of the volume.