steampipe plugin install oci

Table: oci_artifacts_repository - Query OCI Artifacts Repositories using SQL

Oracle Cloud Infrastructure (OCI) Artifacts is a fully managed, scalable, and secure service for sharing and tracking software packages. The service can store and distribute packages, manage dependencies, and control versioning. Artifacts supports a variety of package types, including Docker images and Java libraries, among others.

Table Usage Guide

The oci_artifacts_repository table provides insights into repositories within OCI Artifacts. DevOps engineers and developers can gain detailed visibility into their repositories through this table, including their configurations, associated packages, and metadata. Use it to manage and track software packages, control versioning, and ensure the integrity and security of your software supply chain.

Examples

Basic info

Explore the basic information of your OCI artifact repositories to understand their immutability, lifecycle state, and other key details. This can be useful in managing your repositories and ensuring proper configuration and state.

select
display_name,
id,
is_immutable,
description,
lifecycle_state as state
from
oci_artifacts_repository;
select
display_name,
id,
is_immutable,
description,
lifecycle_state as state
from
oci_artifacts_repository;

List immutable repositories

Explore which repositories have been marked as immutable in your Oracle Cloud Infrastructure. This can be useful for understanding your data's security and compliance status, as immutable repositories cannot be changed or deleted, ensuring the integrity of stored data.

select
display_name,
id,
time_created,
is_immutable,
description,
lifecycle_state
from
oci_artifacts_repository
where
is_immutable;
select
display_name,
id,
time_created,
is_immutable,
description,
lifecycle_state
from
oci_artifacts_repository
where
is_immutable = 1;

List repositories created in last 30 days

Discover the latest repositories that have been created in the last 30 days to understand their lifecycle state and immutability status. This can be useful for auditing purposes, ensuring that all recent additions comply with your organization's policies and standards.

select
display_name,
id,
time_created,
is_immutable,
description,
lifecycle_state
from
oci_artifacts_repository
where
time_created >= now() - interval '30' day;
select
display_name,
id,
time_created,
is_immutable,
description,
lifecycle_state
from
oci_artifacts_repository
where
time_created >= datetime('now', '-30 day');

List available repositories

Explore which artifact repositories are currently available. This is useful for assessing the resources you have at your disposal for storing and managing your software artifacts.

select
display_name,
id,
time_created,
lifecycle_state
from
oci_artifacts_repository
where
lifecycle_state = 'AVAILABLE';
select
display_name,
id,
time_created,
lifecycle_state
from
oci_artifacts_repository
where
lifecycle_state = 'AVAILABLE';

Schema for oci_artifacts_repository

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
compartment_idtext=The OCID of the compartment in Tenant in which the resource is located.
defined_tagsjsonbDefined tags for this resource. Each key is predefined and scoped to a
descriptiontextThe repository description.
display_nametext=The repository name.
freeform_tagsjsonbFree-form tags for this resource. Each tag is a simple key-value pair with no
idtext=The OCID (https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the repository.
is_immutableboolean=Whether the repository is immutable. The artifacts of an immutable repository cannot be overwritten.
lifecycle_statetext=The current state of the repository.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp with time zoneAn RFC 3339 timestamp indicating when the repository 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_artifacts_repository