Re: Who deleted a user profile object

[Marc Rauzier <marc.rauzier@xxxxxxxxx>]

Le 06/09/2022 à 18:10, Art Tostaine, Jr. a écrit :
> I've been trying to look at journals to see who deleted a user profile.
> I've tried several statements like this:
>
> SELECT journal_code, journal_entry_type, object, object_type, X.*
> FROM TABLE (QSYS2.Display_Journal('QSYS', 'QAUDJRN',
> JOURNAL_ENTRY_TYPES => 'CP'
Try to look for DO Delete Objects entries, assuming audit is in place 
through system values for deletions.
> ) ) AS x
> ORDER BY entry_timestamp DESC;
>
> I only see entries from today. What am I doing wrong?  Thank you.