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	Req?	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 and white print counter (machine).
cntSHEETSCOLORPRINT	int	.		Color print counter (machine).
cntSHEETSBLACKCOPY	int	.		black and 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			Paper levels in input trays.
cntINPUTOTHER	tinyint			Paper levels in input trays.
cntOUTPUTBIN1	tinyint			Paper levels in input trays.
cntOUTPUTBIN2	tinyint			Paper levels in input trays.
cntOUTPUTOTHER	smallint			Paper levels in input trays.
cntCOVERAGEAVG	smallint			rate, all colors combined, of coverage of pages processed in the interval.
cntCOVERAGEBLACK	smallint			Average ink coverage in black and white
cntCOVERAGECYAN	smallint			Average ink coverage per color
cntCOVERAGEMANGETA	smallint			Average ink coverage per color
cntCOVERAGEYELLOW	smallint			Average ink coverage per color
-- new 4.2 cntMOVED -- new 5.1	tinyint			Replication flag.
cntIPADDRESS	VARCHAR(128)			Device IP (5.1).
cntSHEETSCOLORLOW	int			Color pages by coverage level (low).
cntSHEETSCOLORMEDIUM	int			Color pages by coverage level (medium).
cntSHEETSCOLORHIGH	int			Color pages by coverage level (high).
cntSHEETSEXTRA1	int			Spare counters.
cntSHEETSEXTRA2	int			Spare counters.