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. |