steampipe plugin install oci

Table: oci_identity_tag_default - Query OCI Identity Tag Defaults using SQL

Oracle Cloud Infrastructure (OCI) Identity Tag Defaults is a feature within the OCI Identity service that allows you to define default tags to be applied to all resources at the time of creation within a specific compartment. These default tags help in organizing and tracking resources, improving cost tracking, security, and compliance across the OCI resources. The tag defaults are inherited by all new resources created in the compartment and can be overwritten during or after the resource creation.

Table Usage Guide

The oci_identity_tag_default table provides insights into the default tags within OCI Identity. As a cloud administrator or security analyst, explore tag-specific details through this table, including tag namespace, value, and lifecycle state. Utilize it to uncover information about default tags, such as their applicability to specific resources, their lifecycle states, and the compartments they are associated with.

Examples

Basic info

Analyze the settings to understand the necessity and lifecycle status of various elements within your OCI Identity Tag Default. This can help in assessing the importance and current stage of each element, aiding in efficient resource management.

select
id,
is_required,
lifecycle_state
from
oci_identity_tag_default;
select
id,
is_required,
lifecycle_state
from
oci_identity_tag_default;

List active tag defaults

Explore which tag defaults are currently active within your OCI identity configuration. This can help manage and organize your resources effectively.

select
id,
is_required,
lifecycle_state
from
oci_identity_tag_default
where
lifecycle_state = 'ACTIVE';
select
id,
is_required,
lifecycle_state
from
oci_identity_tag_default
where
lifecycle_state = 'ACTIVE';

List required tag defaults

Determine the required tag defaults within your OCI identity to ensure compliance and manage resources effectively. This query is particularly useful in identifying and understanding the lifecycle state of these mandatory tag defaults.

select
id,
is_required,
lifecycle_state
from
oci_identity_tag_default
where
is_required;
select
id,
is_required,
lifecycle_state
from
oci_identity_tag_default
where
is_required = 1;

Schema for oci_identity_tag_default

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
compartment_idtext=The OCID of the compartment in Tenant in which the resource is located.
idtext=The OCID of the tag default.
is_requiredbooleanIf you specify that a value is required, a value is set during resource creation (either by the user creating the resource or another tag default). If no value is set, resource creation is blocked.If the `isRequired` flag is set to true, the value is set during resource creation.If the `isRequired` flag is set to false, the value you enter is set during resource creation.
lifecycle_statetext=The tag default's current state.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tag_definition_idtextThe OCID of the tag definition.
tag_definition_nametextThe name used in the tag definition.
tag_namespace_idtextThe OCID of the tag namespace that contains the tag definition.
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 zoneDate and time the tagDefault was created.
titletextTitle of the resource.
valuetextThe default value for the tag definition.

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_identity_tag_default