Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
cups_jobs
Returns all completed print jobs from cups.
Column | Type | Description |
---|---|---|
completed_time | integer | When the job completed printing |
creation_time | integer | When the print request was initiated |
destination | text | The printer the job was sent to |
format | text | The format of the print job |
processing_time | integer | How long the job took to process |
size | integer | The size of the print job |
title | text | Title of the printed job |
user | text | The user who printed the job |
See what file format are being printed to what printer. This is useful for identifying systems that print a lot, which can help you ensure they have access to faster printers. Using this table, you could also highlight slow print jobs that might benefit from troubleshooting.
SELECT destination, format, strftime('%Y-%m-%d %H:%M:%S',creation_time,'unixepoch') AS creationDate FROM cups_jobs;