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 Policysn\_disco\_certmgmt\_notification\_policy \(Version 4.2.0 Certificate Inventory and Management\) | Stores the Microsoft Teams channel notification settings for certificate events. |
Parent Topic:Certificate Inventory and Management reference