This table describes all shared printers and their properties.
|
Field name |
Data type |
Description |
|
id_snapshot |
number |
network snapshot auto-number |
|
id_printer |
number |
Identifier of the printer record (link aces/object_id. |
|
id_share |
number |
Identifier of the share record sharing this printer. |
|
name |
string |
Name of the printer. |
|
port |
string |
Physical port of the printer. |
|
state |
number |
Describes the current status of the printer (see Appendix 1). |
|
ppm |
number |
Number of pages printable per minute. |
|
location |
string |
Physical location of the printer. |
|
nbjobs |
number |
Number of jobs. |
|
account_name |
string |
Full account name of the printer's owner. |
|
driver |
string |
device driver of the printer (link to devices/devicename) |
|
PrintProcessor |
string |
Print processor |
|
DataType |
string |
Commonly RAW or EMF |
|
SpoolDirectory |
string |
Spooler directory for the print queue |
|
HorizontalDPI |
number |
Horizontal resolution in DPI |
|
Vertical DPI |
number |
Vertical resolution in DPI |
|
MaxDPI |
number |
Maximum resolution in dot per inch |
|
Attributes |
number |
|
|
Orientation |
number |
1 = Portrait/ 0 = Landscape |
|
PaperSize |
number |
See appendix 2 for the meaning of the number |
|
PaperLength |
number |
Paper length in mm |
|
PaperWidth |
number |
Paper width in mm |
|
Color |
number |
1 = Yes / 0 = No |
|
Zoom |
number |
Zoom in % |
|
DoubleSided |
number |
Double sided 1 = Yes / 0 = No |
|
PaperSource |
number |
Number of the paper source |
|
Name |
Value |
Meaning |
|
PRINTER_STATUS_BUSY |
0x00000200 |
The printer is busy. |
|
PRINTER_STATUS_DOOR_OPEN |
0x00400000 |
The printer cover is open. |
|
PRINTER_STATUS_ERROR |
0x00000002 |
The printer is in an error state. |
|
PRINTER_STATUS_INITIALIZING |
0x00008000 |
The printer is initializing. |
|
PRINTER_STATUS_IO_ACTIVE |
0x00000100 |
The printer is in an active input/output state |
|
PRINTER_STATUS_MANUAL_FEED |
0x00000020 |
The printer is in a manual feed state. |
|
PRINTER_STATUS_NO_TONER |
0x00040000 |
The printer is out of toner. |
|
PRINTER_STATUS_NOT_AVAILABLE |
0x00001000 |
The printer is not available for printing. |
|
PRINTER_STATUS_OFFLINE |
0x00000080 |
The printer is offline. |
|
PRINTER_STATUS_OUT_OF_MEMORY |
0x00200000 |
The printer has run out of memory. |
|
PRINTER_STATUS_OUTPUT_BIN_FULL |
0x00000800 |
The printer's output bin is full. |
|
PRINTER_STATUS_PAGE_PUNT |
0x00080000 |
The printer cannot print the current page. |
|
PRINTER_STATUS_PAPER_JAM |
0x00000008 |
Paper jam |
|
PRINTER_STATUS_PAPER_OUT |
0x00000010 |
The printer is out of paper. |
|
PRINTER_STATUS_PAPER_PROBLEM |
0x00000040 |
The printer has a paper problem. |
|
PRINTER_STATUS_PAUSED |
0x00000001 |
The printer is paused. |
|
PRINTER_STATUS_PENDING_DELETION |
0x00000004 |
The printer is deleting a job. |
|
PRINTER_STATUS_POWER_SAVE |
0x01000000 |
|
|
PRINTER_STATUS_PRINTING |
0x00000400 |
The printer is printing. |
|
PRINTER_STATUS_PROCESSING |
0x00004000 |
The printer is processing a job. |
|
PRINTER_STATUS_SERVER_UNKNOWN |
0x00800000 |
|
|
PRINTER_STATUS_TONER_LOW |
0x00020000 |
The printer's toner is low. |
|
PRINTER_STATUS_USER_INTERVENTION |
0x00100000 |
The printer requires user's intervention. |
|
PRINTER_STATUS_WAITING |
0x00002000 |
The printer is waiting. |
|
PRINTER_STATUS_WARMING_UP |
0x00010000 |
The printer is warming up. |
|
Constant Name |
Value |
Meaning |
|
|
1 |
Letter 8 1/2 x 11 in |
|
|
2 |
Letter Small 8 1/2 x 11 in |
|
|
3 |
Tabloid 11 x 17 in |
|
|
4 |
Ledger 17 x 11 in |
|
|
5 |
Legal 8 1/2 x 14 in |
|
|
6 |
Statement 5 1/2 x 8 1/2 in |
|
|
7 |
Executive 7 1/4 x 10 1/2 in |
|
|
8 |
A3 297 x 420 mm |
|
|
9 |
A4 210 x 297 mm |
|
|
10 |
A4 Small 210 x 297 mm |
|
|
11 |
A5 148 x 210 mm |
|
|
12 |
B4 (JIS) 250 x 354 |
|
|
13 |
B5 (JIS) 182 x 257 mm |
To view all printers shared by the server MYSERVER, use the following SQL Query:
SELECT printers.name, printers.location FROM printers, shares WHERE shares.id_share = printers.id_share AND shares.server_name = 'MYSERVER'