Re: Are there audit journal entries for WRKREGINF changes?

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Found it.  H/A software was the culprit.
  SELECT
            program_name,
            entry_timestamp,
            entry_type, entry_type_detail,
            qualified_job_name,
            user_profile_name,
            function_registration_operation,
            function_name,
            usage_setting, previous_usage
  FROM TABLE (
      SYSTOOLS.AUDIT_JOURNAL_GR (STARTING_TIMESTAMP => CURRENT timestamp -
20 days))
  WHERE ENTRY_TYPE = 'F'
      and action <> 'ZR'
      and function_name = 'QIBM_Q1A_RCY'
  ;

On Mon, Mar 6, 2023 at 8:17 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

> Upon running the SETUSRBRM I see
> Code . . . . . . . . :   T  - Audit trail entry
> Type . . . . . . . . :   GR - General purpose audit record
> For each of the BRMS registrations
> I'm going to hunt this down some more...
>
> On Mon, Mar 6, 2023 at 8:05 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
> wrote:
>
> > Are there audit journal entries for WRKREGINF changes?
> > I have to repeatedly run the following because I keep disappearing
> > causing issues with running BRMS stuff.
> > SETUSRBRM USER(ROB) USAGE(*ADMIN)
> > It's gotten to the point where I keep backups with
> > RUNSQL SQL('CREATE TABLE mylib.WRKREGINF AS (SELECT *
> >       FROM QSYS2.FUNCTION_USAGE) WITH DATA')
> >       COMMIT(*NONE) NAMING(*SQL)
> > I'm to the point of thinking of having hourly job schedule entries do the
> > SETUSRBRM.
> > I have a case opened.