steampipe plugin install ocisteampipe 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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
compartment_id	text		The OCID of the compartment in Tenant in which the resource is located.
deferred_fields	jsonb		Parameters that were not specified when the instance configuration was created, but that are required to launch an instance from the instance configuration.
defined_tags	jsonb		Defined 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_name	text		A user-friendly name. Does not have to be unique, and it's changeable.
freeform_tags	jsonb		Free-form tags for resource. This tags can be applied by any user with permissions on the resource.
id	text	=	The OCID of the instance configuration.
instance_details	jsonb		The instance configuration details.
region	text		The OCI region in which the resource is located.
tags	jsonb		A map of tags for the resource.
tenant_id	text		The OCID of the Tenant in which the resource is located.
tenant_name	text		The name of the Tenant in which the resource is located.
time_created	timestamp with time zone		The date and time the instance configuration was created.
title	text		Title 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