CONFIG_ITEM
The CONFIG_ITEM table represents the ITIL configuration items (CI) of the printer. It shows the state of the CI and time stamps of its creation, initial management, last discovery, and other actions. The table does not represent any physical portion of a printer; it is simply an abstract representation of the device.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
CI_ID |
BIGINT |
Primary key. |
|
CI_STATE |
VARCHAR(255) |
The current state of the CI. The options are NEW, MANAGED, MISSING, FOUND, CHANGED, UNMANAGED, and RETIRED. |
|
CREATION_DATE |
TIMESTAMP |
The date when the CI first entered the system. |
|
INITIAL_MANAGEMENT_DATE |
TIMESTAMP |
The date when the CI first entered the MANAGED state or substate. |
|
LAST_AUDIT_DATE |
TIMESTAMP |
The date of the last audit attempted on the CI (whether or successful or not). |
|
PRINTER_ID |
BIGINT |
The foreign key to NETWORK_PRINTER.PRINTER_ID. |
|
LAST_DISCOVERY_DATE |
TIMESTAMP |
The date when the last discovery was attempted on the CI (whether successful or not). |
|
LAST_SUCCESSFUL_AUDIT_DATE |
TIMESTAMP |
The date of the last successful audit of the CI. |
|
LAST_SUCCESSFUL_DISCOVERY_ DATE |
TIMESTAMP |
The date of the last successful discovery of the CI. |
|
DEFAULT_CERT_COMMON_NAME |
VARCHAR(255) |
The name of the default certificate. |
|
DEFAULT_CERT_ISSUER_NAME |
VARCHAR(255) |
The name of the issuer of the certificate. |
|
DEFAULT_CERT_SIGNING_STATUS |
VARCHAR(255) |
The certificate signing status of the printer. The options are SIGNED, INVALID_CERT, NO_CA, and UNKNOWN. |
|
DEFAULT_CERT_VALID_FROM |
TIMESTAMP |
The starting date of the validity of the certificate. |
|
DEFAULT_CERT_VALID_TO |
TIMESTAMP |
The last date of the validity of the certificate. |
|
DEFAULT_CERTIFICATE |
VARCHAR(8190) |
The default certificate. |
|
DEFAULT_CERT_SERIAL_NUMBER |
VARCHAR(255) |
The serial number of the default certificate. |