Created
April 28, 2018 19:57
-
-
Save agrohe21/bc60d5dc155ddd0d3008d0b63d901d6a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CHANNEL LOG | |
SELECT id_batch, channel_id, log_date, logging_object_type, object_name, object_copy, repository_directory, filename, object_id, object_revision, parent_channel_id, root_channel_id FROM pentaho_dilogs.channel_logs; | |
JOB LOG | |
SELECT id_job, channel_id, jobname, status, lines_read, lines_written, lines_updated, lines_input, lines_output, lines_rejected, errors, startdate, enddate, logdate FROM pentaho_dilogs.job_logs | |
JOBENTRY | |
SELECT id_batch, channel_id, log_date, transname, stepname, lines_read, lines_written, lines_updated, lines_input, lines_output, lines_rejected, errors, result, nr_result_rows, nr_result_files FROM pentaho_dilogs.jobentry_logs; | |
TRANS LOG | |
SELECT id_batch, channel_id, transname, status, lines_read, lines_written, lines_updated, lines_input, lines_output, lines_rejected, errors, startdate, enddate, logdate, depdate, replaydate FROM pentaho_dilogs.trans_logs; | |
STEP LOG | |
SELECT id_batch, channel_id, log_date, transname, stepname, step_copy, lines_read, lines_written, lines_updated, lines_input, lines_output, lines_rejected, errors FROM pentaho_dilogs.step_logs; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment