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 Management Studio Express. This has the advantage that you can both create a database and analyze all data stored in the database.
Tracking data
If printer drivers and applications in use on the source computer provide certain values 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., 192.168.131.30) | √ |
| 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 ThinPrint 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 | √ |