Default tables in the Reports database
By default, one database containing these database tables are defined by the data
collectors supplied with the Reports feature.
Database Table | Purpose | Default Properties |
---|---|---|
job_history | Holds the values of job properties specified in the Job Step Progress collector. Values are stored at the beginning and end of processing in each step of a workflow. |
|
job_printing | Holds the values of job and printer properties specified in the Job Print Progress collector. Values are stored when a job starts printing and when it finishes printing successfully. |
|
job_step_durations | Holds the values of job properties specified in the Job Step Duration collector. Values are stored at the completion of each step in the workflow. |
|
printer_status | Holds the values of printer properties specified in the Printer Status collector. Values are stored each time that the Enabled status or Printer status changes. |
|
barcode_reader_actions | Holds the values of barcode reader and user properties specified in the User Actions on Barcode Readers collector. |
|
input_device_actions | Holds the values of input device and user properties specified in the User Actions on Input Devices collector. |
|
inserter_actions | Holds the values of inserter controller and user properties specified in the User Actions on Inserters collector. |
|
job_actions | Holds the values of job and user properties specified in the User Actions on Jobs collector. |
|
printer_actions | Holds the values of printer and user properties specified in the User Actions on Printers collector. |
|
user_actions | Holds the values of user and target user properties specified in the User Actions on Users collector. |
|
Additional database tables
The WritePropsToReportsDatabase step also stores property values in database tables. The step always stores these job property values in the database tables that you specify for the Job properties table and Document properties table properties:- Job.ID
- Job.Phase
- Job.Process
- Job.Reports.EventType
- Job.State
- Job.Step
- job_workflow_props
In addition to the properties listed above, the step stores property values for the job properties that you select in the Job properties to write field.
- doc_workflow_props
In addition to the properties listed above, the step stores document property values for the document properties that you select in the Document properties to write field.
Property values are stored every time the step runs.
- Note:
- Some properties have blank values until the job passes a certain point in a workflow. If the WritePropsToReportsDatabase step runs before a value is set for a property, the property name is included as a column in the database table, but no value is recorded.