|
added the where clause
SELECT
entry_timestamp, user_name, qualified_job_name, program_name,
Program_library, remote_address, t.*
FROM TABLE (
SYSTOOLS.AUDIT_JOURNAL_CD (STARTING_TIMESTAMP *=>* *timestamp*(
'2024-05-28-14.28.23'))
) t
WHERE OBJECT_LIBRARY = 'QSYS' AND
OBJECT_NAME LIKE 'STRDBG' ;
Works like a champ. No programming needed.
On Tue, May 28, 2024 at 2:43 PM Rob Berendt <robertowenberendt@xxxxxxxxx<mailto:robertowenberendt@xxxxxxxxx>>
wrote:
CHGOBJAUD OBJ(QSYS/STRDBG) OBJTYPE(*CMD) OBJAUD(*ALL)Program_library, remote_address, t.*
STRDBG
ENDDBG
DSPJRN JRN(QAUDJRN) FROMTIME(052824 1427) JOB(ROBS1)
Code . . . . . . . . : T - Audit trail entry
Type . . . . . . . . : CD - Command string
Object . . . . . . . :
Type . . . . . . . :
Date . . . . . . . . : 05/28/24
Time . . . . . . . . : 14:28:24.063808
Flag . . . . . . . . : 0
Count/RRN . . . . . : 0
Commit cycle ID . . : 0
Nested commit level : 0
Job . . . . . . . . : 569238/ROB/ROBS1
User profile . . . . : ROB
Program . . . . . . : QCMD
Library . . . . . : QSYS
SELECT
entry_timestamp, user_name, qualified_job_name, program_name,
FROM TABLE (richard@xxxxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxxxx>
SYSTOOLS.AUDIT_JOURNAL_CD (STARTING_TIMESTAMP *=>* *timestamp*(
'2024-05-28-14.28.23'))
) t;
2024-05-28 14:28:24.063808 ROB 569238/ROB/ROBS1 QCMD QSYS 10.14.8<http://10.14.8>.56
On Tue, May 28, 2024 at 2:22 PM Jay Vaughn <jeffersonvaughn@xxxxxxxxx<mailto:jeffersonvaughn@xxxxxxxxx>>
wrote:
Thx Richard, but only until the dev's catch on and start doing
qsys/strdbg.
thanks
Jay
On Tue, May 28, 2024 at 1:12 PM Richard Schoen <
QSYSwrote:
This might be a hammer approach, but I did this with the SIGNOFFcommand a
looong time ago.
Create your own wrapper version of STRDBG and put in place ahead of
relatedin the library list, but have it call the STRDBG from QSYS.you
Then you could create your own log every time STRDBG gets called.
That could probably work for the green screen, but not sure where else
need to call STRDBG from.https://www.ibm.com/support/pages/how-block-cl-command-uses-qibmqcachg
Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxxxx>
----------------------------------------------------------------------
message: 1
date: Tue, 28 May 2024 08:33:21 -0400
from: Jay Vaughn <jeffersonvaughn@xxxxxxxxx<mailto:jeffersonvaughn@xxxxxxxxx>>
subject: Re: Detecting when a user invoked strdbg
thank you vern - the exit points came to mind after I had sent this...
what you sent is very helpful.
thanks
Jay
On Mon, May 27, 2024 at 7:27?PM Vern Hamberg via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>> wrote:
Hi Jay
I believe you can use one of the CL command exit points. Here is a
link that shows how to block use of a command, you can use it to log
users, since part of the example is getting the user -
listcommand-exit-point--
HTH
Vern
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>related
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
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
--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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.