Pnp_queue table

Description

When a print queue is created via PnP, we will store the data of this queue in this table.

We can use this table to consult the details, modify the queue, launch a recreation...

 

Schema

Field

Type

Required

Primary key

Description

queID

uniqueidentifier

*

*

Guid identifier

queMODELID

int

 

 

Reference to pnp_queue_model

queDRIVERID

int

 

 

Reference to pnp_driver

queVENDORID

nvarchar(max)

 

 

Not used, always NULL

queWDQUEUEID

nvarchar(max)

 

 

Identifier of the queue in Watchdoc if declared in Watchdoc, NULL otherwise

queWESID

nvarchar(max)

 

 

WesId in Watchdoc, -1 if no Wes.

queSTATUSID

int

 

 

 Status of the queue following the last operation performed:1 = In the process of creation2 = OK3 = Creation failed4 = In the process of modification5 = Modification failed6 = In the process of deletion7 = Deleted8 = Deletion failed9 = In the process of transfer10 = Transferred11 = Transfer failed12 = In the process of restoration

queSERVERID

nvarchar(max)

 

 

Identifier of the server on which the file is installed

queSERVERFQDN

nvarchar(max)

 

 

 FQDN of the server on which the file is installed

queNAME

nvarchar(max)

 

 

Name of the queue

queFQDN

nvarchar(max)

 

 

FQDN of the queue

queIPADDRESS

nvarchar(64)

 

 

 Not used, always NULL

queLOCATION

nvarchar(max)

 

 

Location of the queue

queCOMMENT

nvarchar(max)

 

 

Comment

quePORTNAME

nvarchar(max)

 

 

Not used, always NULL

queQUEUENAME

nvarchar(max)

 

 

Not used, always NULL

quePRINTINGMODE

nvarchar(max)

 

 

Printing mode : RAW or EMF

queQUALITY

nvarchar(max)

 

 

Print quality (Ex : 300, 600)

queISCOLOR

bit

*

 

Color printing possible

queISDUPLEX

bit

*

 

Duplex printing possible

queSECURITYMODE

int

*

 

Security mode

0 = none

1 = Driver (secured driver)

2 = Watchdoc (secured Wes)

queISSYNC

bit

 

 

Always false, not used

queCREATIONDATE

datetime

*

 

Date of creation of the file

queCREATIONOPE

uniqueidentifier

 

 

OperationId (Guid) of the creation operation

queMODIFICATIONDATE

datetime

 

 

Date of modification or NULL

queMODIFICATIONOPE

uniqueidentifier

 

 

OperationId(Guid) of the last modification operation or NULL

queMOVEDATE

datetime

 

 

Transfer date (from one server to another) or NULL

queMOVEOPE

uniqueidentifier

 

 

OperationId(Guid) of the operation of the last transfer operation or NULL

queSYNCHRONISATIONDATE

datetime

 

 

 Not used : Always null

queSYNCHRONISATIONOPE

uniqueidentifier

 

 

Not used : Always null

queDELETIONDATE

datetime

 

 

Date of deletion of the queue if deleted, or null

queDELETIONOPE

uniqueidentifier

 

 

OperationId(Guid) of the last deletion operation