Queuescounters table

Description

The queuescounters table contains all the information collected in SNMP on the printing devices. This table writes N (number of print queues) lines every 5 minutes and, every hour, these X lines are consolidated into one for each print queue.

Schema

Field	Type	Required	Primary key	Description
cntDATE	datetime	*		Date of the SNMP request.
cntTIMESLOT	int	*	*	Optimization field to calculate an interval.
cntLEVEL	tinyint	*	*	Granularity level of the counter (0=5 min., 1=1 hour (crunch), 2=1 day (crunch)).
cntSERVER	varchar(64)	*	*	Identifier of the Watchdoc server that collected the information.
cntQUEUE	varchar(64)	*	*	Identifier of the print queue.
cntQGROUP	varchar(64)	*		Identifier of the Watchdoc group containing the print queue.
cntSNMP	tinyint	.		SNMP activation on the print queue (0=no, 1=yes)
cntUPTIME	int	.		Time since the print queue was started (in seconds).
cntNETWORKINBOUND	bigint	.		Time of incoming network activity (in seconds).
cntNETWORKOUTBOUND	bigint	.		Outgoing network activity time (in seconds).
cntPINGTIME	float	.		Ping time (in 100 ms).
cntPACKETLOSS	int	.		Number of lost packets.
cntSTORAGEFREE	bigint	.		Available storage space.
cntJOBSQUEUED	int	.		Number of pending documents.
cntPAGESQUEUED	int	.		Number of pending pages.
cntSHEETSTOTAL	int	.		Total sheet counter.
cntSHEETSBLACK	int	.		Black counter (machine).
cntSHEETSCOLOR	int	.		Color counter (machine).
cntSHEETSDUPLEX	int	.		Duplex counter (machine).
cntSHEETSA4	int	.		A4 counter (machine).
cntSHEETSA3	int	.		A3 counter (machine).
cntSHEETSPRINT	int	.		Print counter (machine).
cntSHEETSCOPY	int	.		Photocopy counter (machine).
cntSHEETSSCAN	int	.		Scan counter (machine).
cntSHEETSFAX	int	.		Fax counter (machine).
cntSHEETSBLACKPRINT	int	.		Black & white print counter (machine).
cntSHEETSCOLORPRINT	int	.		Color print counter (machine).
cntSHEETSBLACKCOPY	int	.		Black & white photocopy counter (machine).
cntSHEETSCOLORCOPY	int	.		Color photocopies counter (machine).
cntSHEETSSESSION	int	.		Counter since the last reboot
dltSTATUSUNREACHABLE	int	.		Time in seconds that the printing equipment is unavailable.
dltSTATUSERROR	int	.		Time (in seconds) during which the printing device was in error.
dltSTATUSOFFLINE	int	.		Time (in seconds) during which the printing device was blocked.
dltSTATUSPAUSED	int	.		Time (in seconds) during which the printing device was suspended.
dltSTATUSPOWERSAVE	int	.		Time (in seconds) during which the printing device was in standby mode.
dltSTATUSREADY	int	.		Time (in seconds) during which the printing device was "ready".
dltSTATUSWARMINGUP	int	.		Time in seconds in "preheating" of the printing material.
dltSTATUSPROCESSING	int	.		Time in seconds that the printing material is printing.
cntINKTONERBLACK	tinyint	.		Percentage of black toner remaining
cntINKTONERCYAN	tinyint	.		Percentage of cyan toner remaining
cntINKTONERMAGENTA	tinyint	.		Percentage of magenta toner remaining
cntINKTONERYELLOW	tinyint	.		Percentage of yellow toner remaining
cntINKDRUMBLACK	tinyint	.		Percentage of black drum remaining
cntINKDRUMCYAN	tinyint	.		Percentage of cyandrum remaining
cntINKDRUMMAGENTA	tinyint	.		Percentage of magenta drum remaining
cntINKDRUMYELLOW	tinyint	.		Percentage of yellow drum remaining
cntINKFUSER	tinyint	.		Percentage of fuser remaining
cntINKTRANSFER	tinyint	.		Percentage of transfer kit remaining
cntINKWASTE	tinyint	.		Percentage of recovery bottle remaining
cntINKSTAPLES	tinyint	.		Percentage of staple remaining
cntINPUTTRAY1	tinyint	.		Percentage of drawer 1 full
cntINPUTTRAY2	tinyint	.		Percentage fill of drawer 2
cntINPUTTRAY3	tinyint	.		Percentage fill of drawer 3
cntINPUTTRAY4	tinyint	.		Percentage fill of drawer 4
cntINPUTMANUAL	tinyint
cntINPUTOTHER	tinyint
cntOUTPUTBIN1	tinyint
cntOUTPUTBIN2	tinyint
cntOUTPUTOTHER	smallint
cntCOVERAGEAVG	smallint			rate, all colors combined, of coverage of pages processed in the interval.
cntCOVERAGEBLACK	smallint			detail by color
cntCOVERAGECYAN	smallint
cntCOVERAGEMANGETA	smallint
cntCOVERAGEYELLOW	smallint
-- new 4.2 cntMOVED -- new 5.1	tinyint
cntIPADDRESS	VARCHAR(128)
cntSHEETSCOLORLOW	int
cntSHEETSCOLORMEDIUM	int
cntSHEETSCOLORHIGH	int
cntSHEETSEXTRA1	int
cntSHEETSEXTRA2	int