The following query will show you the # of Audit Entry types by date and
It only lists entry types 'AF PW CA CO CD' between 1/21/2023 and 1/23/2023.
Date(ENTRY_TIMESTAMP) as ENTRY_DATE,
CURRENT_USER as CURRENT_USER,
JOURNAL_ENTRY_TYPE as JOURNAL_ENTRY_TYPE,
FROM TABLE (
STARTING_RECEIVER_NAME => '*CURCHAIN',
STARTING_TIMESTAMP => '2023-01-21-00.00.00.000000',
ENDING_TIMESTAMP => '2023-01-23-18.104.22.1689999',
JOURNAL_CODES => 'T',
JOURNAL_ENTRY_TYPES => 'AF PW CA CO CD'
) ) AS X
GROUP BY Date(ENTRY_TIMESTAMP),
ORDER BY Date(ENTRY_TIMESTAMP),
You can get the detail of these entries by using some IBM I Services that
exist for different entries.
Example table function AUDIT_JOURNAL_AF returns data for Authority Failures.
You can also use the CPYAUDJRNE command that creates an output file for each
Audit Code you list if you prefer.
If you're trying to see what Programmers or Admins are doing, the best entry
to look at is CD (Command String) that logs all of the commands they run.
Note this does require *CMD auditing be assigned to the profile using the
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Sent: Tuesday, January 24, 2023 9:11 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Programs or similar to display the system audit log
Can someone guide me where to find some code to analyse the system audit
Assuming you have the proper auditing set up, a good starting point would be
starting with IBM Navigator for i, Audit Journal Entries.
Here you will have some good options to investigate.
No trees were killed in the sending of this message, but a large number of
electrons were terribly upset.
+46 732 369934
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
As an Amazon Associate we earn from qualifying purchases.