Certificate Inventory and Management tables
This framework supports security, compliance, and streamlined operations. Certificate Inventory and Management tables provide a centralized system to track and manage digital certificates. They capture key details, including discovered certificates, installation locations, historical data, and associated tasks such as renewals and requests.
| Table | Description |
|---|---|
| Unique Certificate [cmdb_ci_certificate] |
The Fingerprint column is unique for every server certificate. Note: You can also view the entire certificate chain using the related list in the Unique Certificate table. |
| Installed Certificate [sn_disco_certmgmt_cmdb_installed_certificate] |
Discovery populates this table with all discovered certificates and shows all locations where certificates are installed. It does not have a reference to the server CI and does not go through IRE. Relationships with the managed certificate are stored in the CI Relationship [cmdb_rel_ci] table. The relationships can be for servers, applications, or business services. |
| Discovered Certificate [sn_disco_certmgmt_certificate_history] |
Discovered certificates are stored in this table first as part of the Shazzam and URL discovery sensor and shows the XML payload of all certificates with that address. |
| Certificate Domain [certificate_domain] |
Contains one or more domains for the subject alternative name. |
| Certificate Task [sn_disco_certmgmt_certificate_task] |
Contains all certificate renewal tasks and new certificate request tasks. |
| Certificate URL [sn_disco_certmgmt_cert_url] |
Contains URLs targeted for certificate discovery. |
| Certificate Management Credential [sn_disco_certmgmt_certificate_management_credential] (Version 1.1.7 Certificate Inventory and Management) |
Stores the CA types including GoDaddy and DigiCert. Others are populated based on the certificate_authority script. Only discovery_admin can create other CA credentials. |
| Scheduled Certificate URL [sn_discovery_cert_url_sched_m2m] |
Links the URLs to discover [discovery_cert_url] to a particular Discovery schedule [discovery_schedule]. |
| Certificate Authority [sn_disco_certmgmt_ca] (Version 1.3.8 Certificate Inventory and Management) |
Contains the Certificate Authority name and base URL of the REST API. |
| Certificate Authority API URL [sn_disco_certmgmt_ca_api_url] (Version 1.3.8 Certificate Inventory and Management) |
Contains the reference of certificate authority, end point URL of REST API, and certificate validation type. |
| Routing Policy [sn_disco_certmgmt_routing_policy] (Version 1.3.8 Certificate Inventory and Management) |
Determines which CA to contact for certificate operations. This table contains the CA, CA URL, Credential, Approval Group, Assignment Group, and CSR attributes. |
| Automated Certificate Task [sn_disco_certmgmt_task] (Version 1.3.8 Certificate Inventory and Management) |
Contains all automated certificate request tasks (new, renew, and revoke). |
| New Certificate Tasks [sn_disco_certmgmt_new_task] (Version 1.3.8 Certificate Inventory and Management) |
Extends from [sn_disco_certmgmt_task] and contains new certificate request tasks. |
| Renew Certificate Tasks [sn_disco_certmgmt_renew_task] (Version 1.3.8 Certificate Inventory and Management) |
Extends from [sn_disco_certmgmt_task] and contains renew certificate request tasks. |
| Revoke Certificate Tasks [sn_disco_certmgmt_revoke_task] (Version 1.3.8 Certificate Inventory and Management) |
Extends from [sn_disco_certmgmt_task] and contains revoke certificate request tasks. |
| Certificate Extensions [sn_disco_certmgmt_certificate_extension] (Version 1.3.8 Certificate Inventory and Management) |
Stores information for all server certificates. |
| Microsoft Teams Channel [sn_disco_certmgmt_microsoft_teams_channel] (Version 4.2.0 Certificate Inventory and Management) |
Stores the Microsoft Teams channel configuration. |
| Certificate Notification Policy sn_disco_certmgmt_notification_policy (Version 4.2.0 Certificate Inventory and Management) |
Stores the Microsoft Teams channel notification settings for certificate events. |