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_instance

An core instance is a virtual server in the Oracle Cloud Infrastructure cloud.

Examples

Basic info

select
display_name,
id,
time_created,
lifecycle_state as state,
shape,
region
from
oci_core_instance;

List instances along with the compartment details

select
inst.display_name,
inst.id,
inst.shape,
inst.region,
comp.name as compartment_name
from
oci_core_instance inst
inner join
oci_identity_compartment comp
on (inst.compartment_id = comp.id)
order by
comp.name,
inst.region,
inst.shape;

Count the number of instances by shape

select
shape,
count(shape) as count
from
oci_core_instance
group by
shape;

.inspect oci_core_instance

OCI Core Instance

NameTypeDescription
agent_configjsonbOptions for the Oracle Cloud Agent software running on the instance.
availability_configjsonbOptions for defining the availabiity of a VM instance after a maintenance event that impacts the underlying hardware.
availability_domaintextThe availability domain the instance is running in.
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
dedicated_vm_host_idtextThe OCID of dedicated VM host.
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. Does not have to be unique, and it's changeable.
extended_metadatajsonbAdditional metadata key/value pairs that user provided to instance.
fault_domaintextThe name of the fault domain the instance is running in. A fault domain is a grouping of hardware and infrastructure within an availability domain.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the instance.
instance_optionsjsonbOptional mutable instance options.
ipxe_scripttextWhen a bare metal or virtual machine instance boots, the iPXE firmware that runs on the instance is configured to run an iPXE script to continue the boot process.
launch_modetextSpecifies the configuration mode for launching virtual machine (VM) instances.
launch_optionsjsonbLaunchOptions Options for tuning the compatibility and performance of VM shapes.
lifecycle_statetextThe current state of the instance.
metadatajsonbCustom metadata that you provided to instance.
platform_configjsonbThe platform configuration for the instance.
regiontextThe OCI region in which the resource is located.
shapetextThe shape of the instance. The shape determines the number of CPUs and the amount of memory allocated to the instance.
shape_configjsonbThe shape configuration for an instance. The shape configuration determines the resources allocated to an instance.
source_detailsjsonbContains the details of the source image for the instance.
system_tagsjsonbTags added to instances 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 instance was created
time_maintenance_reboot_duetimestamp without time zoneThe date and time the instance is expected to be stopped/started. After that time if instance hasn't been rebooted, Oracle will reboot the instance within 24 hours of the due time.
titletextTitle of the resource.