Assets table

Description

The "assets" table contains all the information about a print queue. It is fed by a weekly script.

 

Schema

Field

Type

Required

Primary key

Description

astQUEUE

varchar(64)

*

 

 Watchdoc Id of the print queue

astGUID

varchar(64)

 

 

Guid (unique identifier) of the print queue generated by Watchdoc.

astGENERATION

int

*

 

Number of modification in Watchdoc on the print queue

astNAME

nvarchar(255)

*

 

Name of the print queue on the print server.

astQGROUP

varchar(64)

*

 

Name of the Watchdoc group of the print queue

astSERVER

varchar(64)

*

 

Name of the print server

astTYPE

varchar(16)

*

 

Mode of operation of the print queue

astLOCATION

nvarchar(255)

.

 

Location of the print queue

astDESCRIPTION

nvarchar(255)

.

 

 Description of the print queue

astIP

varchar(64)

.

 

IP address of the print queue

astBRAND

varchar(20)

.

 

Brand of the print queue

astDRIVER

nvarchar(255)

.

 

 Driver of the print queue

astDRIVERVERSION

varchar(32)

.

 

Version of the printer driver

astCOLORCAPABLE

tinyint

.

 

Can it do color?

astKIND

varchar(16)

.

 

Category of the print queue

astSERIALNUMBER

varchar(64)

.

 

Number of the print queue

astTAG

varchar(64)

.

 

Tag entered in Watchdoc

astLABELS

nvarchar(255)

.

 

Model of the print queue

astINSTALLDATE

datetime

.

 

Creation date in Watchdoc

astUPDATE

datetime

.

 

Date of modification in Watchdoc

astARCHIVED

tinyint

.

 

Is it archived?

astPORT

varchar(64)

.

 

Name of the port used by the print queue

astMODEL

nvarchar(255)

 

 

RFU