PRINTER_STATISTICS
This table contains information gathered from the meters and counters data of the printer. Each row represents data for an individual printer. Depending on the printer model with which the record is associated, not all columns apply.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
STATISTICS_ID |
BIGINT |
The primary key. |
|
COVG_LAST_JOB_BLACK |
BIGINT |
The black toner coverage of the last print job. |
|
COVG_LIFETIME_BLACK |
BIGINT |
The black toner coverage of jobs from the currently installed black cartridge. |
|
CART_PAGES_PRINT_BLACK |
BIGINT |
The count of the printed pages that used black toner cartridge. |
|
BLACK_TONER_LEVEL |
VARCHAR(255) |
The current supply level of the black toner cartridge. |
|
PHOTO_COND_LEVEL_K |
VARCHAR(255) |
The current supply level of the photoconductor (black). |
|
BLANK_SAFE_SIDE_COPY |
BIGINT |
The count of the blank safe sides from a copy. |
|
BLANK_SAFE_SIDE_FAX |
BIGINT |
The count of the blank safe sides from a fax. |
|
BLANK_SAFE_SIDE_PRINT |
BIGINT |
The count of the blank safe sides from a print. |
|
PAPER_CHANGE |
BIGINT |
The count of paper change events. |
|
COVER_OPEN |
BIGINT |
The count of cover open events. |
|
COVG_LAST_JOB_CYAN |
BIGINT |
The cyan toner coverage of the last print job. |
|
COVG_LIFETIME_CYAN |
BIGINT |
The cyan toner coverage of jobs from the currently installed cyan cartridge. |
|
CART_PAGES_PRINT_CYAN |
BIGINT |
The count of the printed pages that used the cyan toner cartridge. |
|
CYAN_TONER_LEVEL |
VARCHAR(255) |
The current supply level of the cyan toner cartridge. |
|
CYAN_TONER_STATUS |
VARCHAR(255) |
The supply status for the cyan cartridge (for example, Intermediate). |
|
YELLOW_TONER_STATUS |
VARCHAR(255) |
The supply status for the yellow cartridge (for example, Intermediate). |
|
MAGENTA_TONER_STATUS |
VARCHAR(255) |
The supply status for the magenta cartridge (for example, Intermediate). |
|
BLACK_TONER_STATUS |
VARCHAR(255) |
The supply status for the black cartridge (for example, Intermediate). |
|
PHOTO_COND_LEVEL_C |
VARCHAR(255) |
The current supply level of the photoconductor (cyan). |
|
DEVICE_INSTALL_DATE |
TIMESTAMP |
The time stamp of the first installation of the printer. |
|
FUSER_CURRENT_LEVEL |
VARCHAR(255) |
The current supply level of the fuser. |
|
IMG_SAFE_SIDE_COPY |
BIGINT |
The count of imaged printed sides of a copy job. |
|
IMG_SAFE_SIDE_FAX |
BIGINT |
The count of imaged printed sides of a fax job. |
|
IMG_SAFE_SIDE_PRINT |
BIGINT |
The count of imaged printed sides of a print job. |
|
LAST_FAX_JOB_DATE |
TIMESTAMP |
The time stamp of the last fax job. |
|
LAST_PRINTED_JOB_DATE |
TIMESTAMP |
The time stamp of the last print job. |
|
LAST_SCAN_JOB_DATE |
TIMESTAMP |
The time stamp of the last scan job. |
|
COVG_LAST_JOB_MAGENTA |
BIGINT |
The magenta toner coverage of the last job. |
|
COVG_LIFETIME_MAGENTA |
BIGINT |
The magenta toner coverage of jobs from the currently installed magenta cartridge. |
|
CART_PAGES_PRINT_MAGENTA |
BIGINT |
The count of the printed pages that used the magenta toner cartridge. |
|
MAGENTA_TONER_LEVEL |
VARCHAR(255) |
The current supply level of the magenta toner cartridge. |
|
PHOTO_COND_LEVEL_M |
VARCHAR(255) |
The current supply level of the photoconductor (magenta). |
|
MAINT_KIT_LEVEL |
VARCHAR(255) |
The current supply level of the maintenance kit. |
|
MEDIA_SIZE_TYPE_MONO_SIDE_ SAFE |
BIGINT |
The mono printed sides (safe). |
|
MEDIA_SIZE_TYPE_COLOR_SIDE_ SAFE |
BIGINT |
The color printed sides (safe). |
|
SUPPLY_EVENTS |
BIGINT |
The count of other supply events. |
|
PAPER_JAMS |
BIGINT |
The count of paper jam events. |
|
PAPER_LOAD |
BIGINT |
The count of paper load events. |
|
PRINT_SHEET_USE_PICKED |
BIGINT |
The printed sheets (picked). |
|
PRINT_SIDE_USE_PICKED |
BIGINT |
The printed sides (picked). |
|
POR |
BIGINT |
The count of Power-On Resets. |
|
PRINT_AND_HOLD_JOB |
BIGINT |
The count of print-and-hold jobs. |
|
SAFE_SHT_COPY |
BIGINT |
The printed sheets (safe) from copy jobs. |
|
SAFE_SHT_FAX |
BIGINT |
The printed sheets (safe) from fax jobs. |
|
SAFE_SHT_PRINT |
BIGINT |
The printed sheets (safe) from print jobs. |
|
SCAN_PAPER_JAMS |
BIGINT |
The count of scanner jams. |
|
PRINTED_FROM_PRINT_AND_HOLD |
BIGINT |
The count of printed print-and-hold jobs. |
|
PRINTED_FROM_USB |
BIGINT |
The count of prints from USB. |
|
TRANS_BELT_LEVEL |
VARCHAR(255) |
The current supply level of the transfer belt. |
|
USB_DIRECT_JOB |
BIGINT |
The count of USB insertions. |
|
WASTE_TONER_LEVEL |
VARCHAR(255) |
The current level of the waste toner bottle. |
|
COVG_LAST_JOB_YELLOW |
BIGINT |
The yellow toner coverage of the last job. |
|
COVG_LIFETIME_YELLOW |
BIGINT |
The yellow toner coverage of lifetime jobs. |
|
CART_PAGES_PRINT_YELLOW |
BIGINT |
The count of the printed pages that used the yellow toner cartridge. |
|
YELLOW_TONER_LEVEL |
VARCHAR(255) |
The current supply level of the yellow toner cartridge. |
|
PHOTO_COND_LEVEL_Y |
VARCHAR(255) |
The current level of the photoconductor (yellow). |
|
IMG_SAFE_SIDE_PRINT_MONO |
BIGINT |
The count of imaged mono printed sides (safe) from print jobs. |
|
IMG_SAFE_SIDE_PRINT_COLOR |
BIGINT |
The count of imaged color printed sides (safe) from print jobs. |
|
IMG_SAFE_SIDE_COPY_MONO |
BIGINT |
The count of imaged mono printed sides (safe) from copy jobs. |
|
IMG_SAFE_SIDE_COPY_COLOR |
BIGINT |
The count of imaged color printed sides (safe) from copy jobs. |
|
IMG_SAFE_SIDE_FAX_MONO |
BIGINT |
The count of imaged mono printed sides (safe) from fax jobs. |
|
IMG_SAFE_SIDE_FAX_COLOR |
BIGINT |
The count of imaged color printed sides (safe) from fax jobs. |
|
FAX_JOB_RECV |
BIGINT |
The count of received fax jobs. |
|
FAX_JOB_SENT |
BIGINT |
The count of sent fax jobs. |
|
FAX_PAGE_RECV |
BIGINT |
The count of received fax pages. |
|
FAX_PAGE_SENT |
BIGINT |
The count of sent fax pages. |
|
SCAN_COPY |
BIGINT |
The count of scans from copy jobs. |
|
SCAN_FAX |
BIGINT |
The count of scans from fax. |
|
SCAN_LOCAL |
BIGINT |
The count of local scans. |
|
SCAN_NET |
BIGINT |
The count of scans to network. |
|
SCAN_FLAT |
BIGINT |
The count of scans from the scanner glass flatbed. |
|
SCAN_ADF_SIMPLEX |
BIGINT |
The count of scans from the ADF (simplex). |
|
SCAN_ADF_DUPLEX |
BIGINT |
The count of scans from the ADF (duplex). |
|
SCAN_USB_DIRECT |
BIGINT |
The count of scans directly to USB. |
|
USB_DIRECT_INSERT |
BIGINT |
The count of USB insertions. |
|
CART_INST_DATE_CYAN |
TIMESTAMP |
The time stamp of the cyan cartridge installation. |
|
CART_INST_DATE_YELLOW |
TIMESTAMP |
The time stamp of the yellow cartridge installation. |
|
CART_INST_DATE_MAGENTA |
TIMESTAMP |
The time stamp of the magenta cartridge installation. |
|
CART_INST_DATE_BLACK |
TIMESTAMP |
The time stamp of the black cartridge installed. |
|
PRINTER_ID |
BIGINT |
The foreign key to NETWORK_PRINTER.PRINTER_ID. |
|
MAINT_KIT_STATUS_100K |
VARCHAR(255) |
The 100K maintenance kit level. |
|
MAINT_KIT_STATUS_160K |
VARCHAR(255) |
The 160K maintenance kit level. |
|
MAINT_KIT_STATUS_200K |
VARCHAR(255) |
The 200K maintenance kit level. |
|
MAINT_KIT_STATUS_300K |
VARCHAR(255) |
The 300K maintenance kit level. |
|
MAINT_KIT_STATUS_320K |
VARCHAR(255) |
The 320K maintenance kit level. |
|
MAINT_KIT_STATUS_480K |
VARCHAR(255) |
The 480K maintenance kit level. |
|
MAINT_KIT_STATUS_600K |
VARCHAR(255) |
The 600K maintenance kit level. |