steampipe plugin install oci

Table: oci_adm_knowledge_base - Query OCI ADM Knowledge Bases using SQL

Oracle Cloud Infrastructure (OCI) Audit and Data Management (ADM) Knowledge Base is a cloud-based service that provides a centralized repository for managing and accessing information related to your OCI resources. This service is designed to help users manage, share, and access knowledge across their organization, including information about OCI resources, incidents, and solutions. It enables users to efficiently retrieve information, reduce resolution time, and improve operational efficiency.

Table Usage Guide

The oci_adm_knowledge_base table provides insights into the Knowledge Bases within Oracle Cloud Infrastructure's Audit and Data Management (ADM). As a cloud administrator or a DevOps engineer, you can explore detailed information about your organization's knowledge bases, including the associated incidents, solutions, and other related resources. Utilize this table to maintain an efficient knowledge management system, streamline incident resolution, and enhance operational efficiency within your organization.

Examples

Basic info

Explore which knowledge base entries are active or inactive within your Oracle Cloud Infrastructure. This can help you manage and organize your resources effectively.

select
id,
display_name,
compartment_id,
tenant_id,
lifecycle_state as state
from
oci_adm_knowledge_base;
select
id,
display_name,
compartment_id,
tenant_id,
lifecycle_state as state
from
oci_adm_knowledge_base;

List knowledge bases which are not active

Discover the segments that consist of inactive knowledge bases. This can be particularly useful when carrying out maintenance or auditing tasks, as it helps identify areas that may require attention or updates.

select
id,
display_name,
compartment_id,
tenant_id,
lifecycle_state as state
from
oci_adm_knowledge_base
where
lifecycle_state <> 'ACTIVE';
select
id,
display_name,
compartment_id,
tenant_id,
lifecycle_state as state
from
oci_adm_knowledge_base
where
lifecycle_state <> 'ACTIVE';

List knowledge bases created in last 30 days

Discover the knowledge bases that have been created within the past 30 days to maintain an up-to-date understanding of your data resources and ensure you're tracking recent developments.

select
id,
display_name,
compartment_id,
tenant_id,
lifecycle_state as state
from
oci_adm_knowledge_base
where
time_created >= now() - interval '30' day;
select
id,
display_name,
compartment_id,
tenant_id,
lifecycle_state as state
from
oci_adm_knowledge_base
where
time_created >= datetime('now', '-30 day');

List knowledge bases that have not been updated for more than 90 days

Discover the segments that have not been frequently updated, specifically knowledge bases that have been dormant for more than 90 days. This can be useful for identifying potentially outdated or unused resources that may require attention or cleanup.

select
id,
display_name,
compartment_id,
tenant_id,
lifecycle_state as state
from
oci_adm_knowledge_base
where
time_updated < now() - interval '90' day;
select
id,
display_name,
compartment_id,
tenant_id,
lifecycle_state as state
from
oci_adm_knowledge_base
where
time_updated < datetime('now', '-90 day');

Schema for oci_adm_knowledge_base

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
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 namespace.
display_nametext=The name of the Knowledge Base.
freeform_tagsjsonbSimple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only.
idtext=The Oracle Cloud Identifier (OCID (https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm)) of the Knowledge Base.
lifecycle_statejsonb=The current lifecycle state of the Knowledge Base.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
system_tagsjsonbSystem tags for this resource. These predefined keys are scoped to namespaces.
tagsjsonbA map of tags for the resource.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The OCID of the Tenant in which the resource is located.
time_createdtimestamp with time zoneTime that Knowledge Base was created.
time_updatedtimestamp with time zoneTime that Knowledge Base was updated.
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_adm_knowledge_base