pdi_logging extrac

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;