SQL database

577 views 0

SQL server management tools

In addition to the ThinPrint Tracking Report Engine, you can also use management tools for directly accessing the SQL database, such as Microsoft SQL Server Manage­ment Studio Express. This has the advantage that you can both create a database and analyze all data stored in the database.

Microsoft SQL Server Management Studio Express

Microsoft SQL Server Management Studio Express


Tracking data

If printer drivers and applications in use on the source computer provide certain val­ues and the specific version of ThinPrint Engine (or Personal Printing) also supports them, the following information can be sent with each print job to the ThinPrint Tracking Service, which will write it to the SQL database:

Value in the database Meaning Supported by Output Gateway
MachineName IP address of the source computer (e. g.,
DriverName printer driver ID
DestName host name of the target computer (e. g., client-22)
ServerName host name of the source computer (e. g., server-03)
PrinterName name of the printer on the source computer (e. g., HP LaserJet 4#client-22:6)
ID ID in the SQL database
UserName name of the person who printed (= Account)
Orientation paper orientation (portrait or landscape)
PaperSize paper format (e. g., A4, Letter, Executive)
PaperLength paper length (cm) For user defined paper formats, otherwise value = 0
PaperWidth paper width (cm)
Copies number of copies
DefaultSource default paper source
PrintQuality printout quality (maximum value of XRes and YRes; e. g., 600 dpi) or quality level (e. g., fine)
Color color or grayscale (b/w)
Duplex double-sided or single-sided (duplex or simplex)
XRes horizontal resolution (dpi)
YRes vertical resolution (dpi)
TTOption TrueType fonts embedded in the file as bitmap, as soft font, or outline or information about what printer font is to be replaced sent to the printer
dmCollate sorting option; e. g. print longer documents consecutively abhängig von der Anwendung
FormName name of the paper format
JobID print job ID
Status values:

1 = Print job delivered

2 = Successfully printed

3 = Print job canceled

ClientID client-ID
Pages Number of printed pages
TStamp time of print job (start of communication between ThinPrint Engine and ThinPrint Tracking Service)
Duration time (in ms) between start of sending a print job by the Thin­Print Engine (= TStamp) and end of transmission
DevMode device mode Data as blob (binary large object)
printType format of print data

values: m = EMF; r = RAW

JobSize print job size (uncompressed) in Byte
JobTSize print job size (compressed) in Byte
CompressionRate computed by dividing JobTSize by JobSize (with ThinPrint Engine only)
DocumentName name of the document


Previous Page
Next Page

Was this helpful?