iFileAudit from Kisco also captures this information -
https://www.kisco.com/ifa/index.html
Rich Loeber
Kisco Systems LLC
https://www.kisco.com
On 11/26/2025 11:32 AM, Jim Oberholtzer wrote:
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><mailto: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><mailto: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><mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
midrange.com
