Re: Who deleted rows?

To close the loop on this, I discovered two solutions. The easiest what EXPJRNE from tool400.de (Thank you for that tool) It was a challenge to get installed but with some help from Mark, got the job done.

The second is an SQL tool from Roberto De Pedrini:
-- description: DSPJRNTBL
---------------------------------------------------------------------------------------------------
-- FAQ400.CREATE_DISPLAY_JOURNAL_TABLE_VIEW
-- Author : Roberto De Pedrini (FAQ400)
-- https://github.com/Faq400Git/CREATE_DISPLAY_JOURNAL_TABLE_VIEW


Both required some effort to get working but do the job.


--
Jim Oberholtzer
Agile Technology Architects

On Nov 25, 2025, at 4:26 PM, Mark Waterbury via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Jim,
Install the free open-source tool called EXPJRNE from tool400.de -- it makes such tasks trivial.
Mark S. Waterbury
On Tuesday, November 25, 2025 at 05:24:18 PM EST, Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx> wrote:

Oh it does, finding the right data and converting it from the blob to something useful is the challenge.
--
Jim Oberholtzer
Agile Technology Architects

On Nov 25, 2025, at 3:51 PM, Stephen Landess <steve_landess@xxxxxxxxxxx> wrote:

Jim -

The Security Audit Journal (QAUDJRN) can perhaps show you /who/ updated the file,
but unless you have journaling activated on the file in question,
you cannot determine /which/ records were deleted.


Jim Oberholtzer wrote:
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?
--
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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

--
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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.


--
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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.