Certificates

The Certificates service provides centralized lifecycle management for digital certificates used to secure internal and external endpoints (for example, TLS for web services, mutual TLS, client certs). It supports certificate issuance, renewal, rotation, revocation, and inventory, enabling teams to reduce certificate-related outages and maintain compliance. This subject area enables tracking certificates, associations, authorities, and related details.

Business Questions

The subject area can answer the following business questions:

  • How many certificates are present?
  • How many certificates are active today?
  • How many associations are present?
  • What's the certificate count by configuration type?
  • What's the certificate count by profile type?

Logical Model

The Certificates subject area is based on a relationship-driven logical model.

This diagram shows how certificate association data is related to its dimension tables:


Relationship diagram with certificate association data connected to certificate, compartment, region, date, and tenancy dimensions.

This diagram shows how certificate authority data is related to its dimension tables:


Relationship diagram with certificate authority data connected to certificate authority, compartment, region, date, and tenancy dimensions.

This diagram shows how certificate data is related to its dimension tables:


Relationship diagram with certificate data connected to certificate, compartment, region, date, and tenancy dimensions.

Metric Details

The fact folders in this subject area include the following metrics:

Metric Details for Certificates
Subject Area Metric Description
Certificate Management - Association Certificate Management Certificate Association Count COUNT(ocira_fact_key) from the fact view's ocira_fact_key (maps to ocira$fact_key)
Certificate Management - Authority Certificate Management Certificate Authority Count COUNT(ocira_fact_key) from the fact view's ocira_fact_key (maps to ocira$fact_key)
Certificate Management - Authority Issued Certificate Count Provides the number of active certificates referencing this certificate authority.
Certificate Management - Certificate Association Count Provides the number of certificate associations across OCI resources.
Certificate Management - Certificate Certificate Management Certificate Count COUNT(ocira_fact_key) from the fact view's ocira_fact_key (maps to ocira$fact_key)