Is this what you're looking for?
(change the where statement)
select OBJECT as COMMAND,
JOB_NAME,
JOB_USER,
JOB_NUMBER,
ENTRY_TIMESTAMP,
program_name,
program_library,
substr(cast(ENTRY_DATA as char(2048)), 31, 6000) as COMMAND_STRING
from table (
QSYS2.DISPLAY_JOURNAL(
JOURNAL_LIBRARY => 'QSYS',
JOURNAL_NAME => 'QAUDJRN',
STARTING_RECEIVER_NAME => '*CURCHAIN', JOURNAL_ENTRY_TYPES => 'DL', STARTING_TIMESTAMP => '2025-11-25 00:00:01',
ENDING_TIMESTAMP => '2025-11-25 10:36:00'))
where user_name='GWILBURN';
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jim Oberholtzer
Sent: Tuesday, November 25, 2025 4:38 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Who deleted rows?
My day for not finding things. Google/archives etc. no help.
I need to figure out who deleted rows from a table in the last 24 hours.
Anyone have the sql to find it?
--
Jim Oberholtzer
Agile Technology Architects
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://protect.checkpoint.com/v2/r01/___https://lists.midrange.com/mailman/listinfo/midrange-l___.YzJ1OnRvdGFsYml6ZnVsZmlsbG1lbnQxOmM6bzphOWM0ZTMxNzhmNDdlYjFkYzI3MjgzZTg0OGEwMzkxNjo3OmZkYmI6YzI0MTdlOGFmYzE1Mzk3MDIwNzNlNTA3NmM4MWExY2I4YjE1ZGIwMjViZjJmMzkzODU1ZTkwZjYyOTBkM2M3MzpwOlQ6Rg
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://protect.checkpoint.com/v2/r01/___https://archive.midrange.com/midrange-l___.YzJ1OnRvdGFsYml6ZnVsZmlsbG1lbnQxOmM6bzphOWM0ZTMxNzhmNDdlYjFkYzI3MjgzZTg0OGEwMzkxNjo3OjE1YTQ6ODUyM2E2ZmQ5MzBkMjVlMDdhNGIwZjUyMWUxY2UxM2RiYjI2ZGNjMzVhZDU2NWFmMThlMGFmMWVlOGY4MDcxNTpwOlQ6Rg.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
[CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.]
Greg Wilburn
Director of IT
301.895.3792 ext. 1231
midrange.com
