Certificate management
The following represents the list of certifications to be verified.
ENROLLMENT_STATUS
The following table lists the issued certificates.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
ENROLLMENT_STATUS_ID |
BIGINT |
The primary key. |
|
CERTIFICATE_ENROL_STATUS |
VARCHAR(255) |
The certificate enrollment status. The options are Issued, Pending, and Failed. |
|
CERT_ENROL_TRANSACTION_ID |
VARCHAR(2048) |
The pending certificate response for EST. Sometimes, this field shows the transaction ID for certificate enrollment. |
|
CERT_SUBJECT_IDENTITY |
VARCHAR(255) |
The subject identity of the certificate. |
|
CERT_SERIAL_NUMBER |
VARCHAR(255) |
The serial number of the certificate issued. |
|
PRINTER_ID |
BIGINT |
The reference printer. |
|
DEFAULT_CERT_REVISION_NO |
VARCHAR(255) |
The revision number of the certificate that is renewed. |
|
DEFAULT_CERT_RENEWAL_DATE |
VARCHAR(255) |
The renewal date of the certificate. |
|
CERTIFICATE_FRIENDLY_NAME |
VARCHAR(255) |
The friendly name of the certificate. |
|
CERTIFICATE_USED_FOR |
VARCHAR(255) |
The association of the named certificate. The options are DEFAULT, HTTPS, WIRELESS, IPSEC, and UNASSIGNED. |
CA_CERT_REVOCATION_COMP_LIST
The following table lists information about the revoked certificates.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
ID |
BIGINT |
The unique identifier. |
|
SERIAL_NUMBER |
VARCHAR(255) |
The serial number of the certificate present in the revocation list primary key. |
|
CERTIFICATE_SUBJECT |
VARCHAR(255) |
The subject of the revoked certificate. |
|
REVOCATION_DATE |
TIMESTAMP |
The date when the certificate is revoked. |
|
ISSUER |
VARCHAR(255) |
The issuer of the revoked certificate. |
|
REVOCATION_REASON |
VARCHAR(255) |
The revocation reason. |
NAMED_CERTIFICATE_SETTINGS
The following table lists the name and association of named certificate.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
CERT_SETTING_ID |
BIGINT |
The unique identifier. |
|
FRIENDLY_NAME |
VARCHAR(255) |
The friendly name of the named certificate. |
|
CERT_USED_FOR |
VARCHAR(255) |
The association of the named certificate. The options are DEFAULT, HTTPS, WIRELESS, IPSEC, and UNASSIGNED. |
|
CONFIGURATION_COMPONENT_ID |
BIGINT |
The foreign key associated with ID of the CONFIGURATION_COMPONENT table. |
|
TEMPLATE_ID |
BIGINT |
The ID of the associated template. |
PRINTER_CERTIFICATE
The following table represents the details of the named certificate.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
CERTIFICATE_ID |
BIGINT |
The unique identifier. |
|
CERTIFICATE_FRIENDLY_NAME |
VARCHAR(255) |
The friendly name of the certificate. |
|
CERTIFICATE_COMMON_NAME |
VARCHAR(255) |
The common name of the certificate. |
|
CERTIFICATE_ISSUER_NAME |
VARCHAR(255) |
The name of the issuer of the certificate. |
|
CERTIFICATE_SIGNING_STATUS |
VARCHAR(255) |
The signing status of the certificate. The options are SIGNED, INVALID_CERT, NO_CA, REVOKED, and UNKNOWN. |
|
CERTIFICATE_VALID_FROM |
TIMESTAMP |
The time when the certificate started to be valid. |
|
CERTIFICATE_VALID_TO |
TIMESTAMP |
The time when the certificate is no longer valid. |
|
CERTIFICATE_SIGNATURE |
VARCHAR(8190) |
The signature of the certificate. |
|
CERTIFICATE_SERIAL_NUMBER |
VARCHAR(255) |
The serial number of the certificate. |
|
TYPE |
VARCHAR(255) |
The type of the certificate. The options are DEFAULT, HTTPS, WIRELESS, IPSEC, and UNASSIGNED. |
|
PRINTER_ID |
BIGINT |
The foreign key associated with ID of CONFIGURATION_COMPONENT table. |
ENROLLED_CERTIFICATE_TYPE
The following table shows the relationship between certificate and enrollment status.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
TYPE_ID |
BIGINT |
The unique identifier. |
|
ENROLLMENT_STATUS_ID |
BIGINT |
The foreign key of the ID column of ENROLLMENT_STATUS table. |
|
TYPE |
VARCHAR(255) |
The type of the certificate. The options are DEFAULT, HTTPS, WIRELESS, IPSEC, and UNASSIGNED. |
CA_TEMPLATE
The following table shows the details of the templates selected when setting up the MSCA server using the MSCEWS protocol.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
TEMPLATE_ID |
BIGINT |
The unique identifier for templates for MSCA Server with MSCEWS (cannot be null). |
|
TEMPLATE_NAME |
VARCHAR(255) |
The name of templates in the CEP server. |
|
TEMPLATE_OID |
VARCHAR(255) |
The corresponding SNMP MIB path. |