Re: Workstation logon tracking

I added one line to limit it to QINTER

select f.from_job, f.message_timestamp as Start_time, t.End_time
FROM TABLE(QSYS2.HISTORY_LOG_INFO(TIMESTAMP('2017-01-01-00.00.01'),
CURRENT TIMESTAMP)) f
cross join lateral(
select t.message_timestamp as End_Time
FROM TABLE(QSYS2.HISTORY_LOG_INFO(TIMESTAMP('2017-01-01-00.00.01'),
CURRENT TIMESTAMP)) t
where f.from_job=t.from_job
and f.message_id='CPF1124' and t.message_id='CPF1164'
and char(f.message_text) like '%QINTER%'
order by f.from_job
) as t
;


Rob Berendt