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_boot_volume

When you launch a virtual machine (VM) or bare metal instance based on a platform image or custom image, a new boot volume for the instance is created in the same compartment. That boot volume is associated with that instance until you terminate the instance.

Examples

Basic info

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

List boot volumes with faulty state

select
id as boot_volume_id
display_name,
lifecycle_state,
time_created
from
oci_core_boot_volume
where
lifecycle_state = 'FAULTY';

List boot volumes with size greater than 1024 GB

select
id as boot_volume_id,
display_name,
lifecycle_state,
size_in_gbs
from
oci_core_boot_volume
where
size_in_gbs > 1024;

List boot volumes with Oracle managed encryption

Note: Volumes are encrypted by default with Oracled managed encryption key

select
id as boot_volume_id,
display_name,
lifecycle_state,
time_created
from
oci_core_boot_volume
where
kms_key_id is null;

List boot volumes with customer managed encryption

select
id as boot_volume_id,
display_name,
lifecycle_state,
time_created
from
oci_core_boot_volume
where
kms_key_id is not null;

List boot volumes created in the root compartment

select
id as boot_volume_id,
display_name,
lifecycle_state,
tenant_id,
compartment_id
from
oci_core_boot_volume
where
compartment_id = tenant_id;

.inspect oci_core_boot_volume

OCI Core Boot Volume

NameTypeDescription
auto_tuned_vpus_per_gbbigintThe number of Volume Performance Units per GB that this boot volume is effectively tuned to when it's idle.
availability_domaintextThe availability domain of the boot volume.
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
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 boot volume.
is_auto_tune_enabledbooleanSpecifies whether the auto-tune performance is enabled for this boot volume.
is_hydratedbooleanSpecifies whether the boot volume's data has finished copying from the source boot volume or boot volume backup.
kms_key_idtextThe OCID of the Key Management key which is the master encryption key for the boot volume.
lifecycle_statetextThe current state of a boot volume.
regiontextThe OCI region in which the resource is located.
size_in_gbsbigintThe size of the boot volume in GBs.
size_in_mbsbigintThe size of the boot volume in MBs.
source_detailsjsonbThe boot volume source, either an existing volume in the same availability domain or a volume backup.
system_tagsjsonbSystem tags for resource. System tags can be viewed by users, but can only be created by the system.
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 boot 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 boot volume per GB,representing the Block Volume service's elastic performance options.