steampipe plugin install oci

Table: oci_core_instance_configuration - Query OCI Core Instance Configurations using SQL

An OCI Core Instance Configuration is a template that contains the settings to launch a compute instance in the Oracle Cloud Infrastructure Compute service. These configurations capture the instance's metadata, including the OCID, the compartment OCID, and the display name. They also provide details about the instance's launch parameters, such as the instance type, the shape, and the associated networking details.

Table Usage Guide

The oci_core_instance_configuration table provides insights into the instance configurations within OCI's Compute service. As a cloud engineer, explore instance-specific details through this table, including instance type, shape, and associated networking details. Utilize it to uncover information about configurations, such as those associated with specific compartments, the metadata of instances, and the verification of launch parameters.

Examples

Basic info

Explore the general details of your OCI instance configurations to understand when and where they were created. This can aid in managing resources and tracking the deployment of instances across different regions.

select
display_name,
id,
time_created,
region
from
oci_core_instance_configuration;
select
display_name,
id,
time_created,
region
from
oci_core_instance_configuration;

List instance configurations along with the compartment details

Explore the configurations of various instances and their associated compartments to understand how resources are allocated and organized within different regions. This information can be useful for assessing resource distribution and planning for future infrastructure needs.

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

List instance configurations created in the last 30 days

Discover the segments that have been recently added in the past month. This query is useful for keeping track of newly created configurations, aiding in system management and monitoring.

select
display_name,
id,
time_created,
region
from
oci_core_instance_configuration
where
time_created >= now() - interval '30' day;
select
display_name,
id,
time_created,
region
from
oci_core_instance_configuration
where
time_created >= datetime('now', '-30 day');

Schema for oci_core_instance_configuration

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
deferred_fieldsjsonbParameters that were not specified when the instance configuration was created, but that are required to launch an instance from the instance configuration.
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.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtext=The OCID of the instance configuration.
instance_detailsjsonbThe instance configuration details.
regiontextThe OCI region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The 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 instance configuration was created.
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- oci

You can pass the configuration to the command with the --config argument:

steampipe_export_oci --config '<your_config>' oci_core_instance_configuration