How do I schedule the Archived User Profiles report ZPQY2601? (NETIQKB51192)

fact
Profile and Password Management (PPM)

fact
PSSecure 7.5

fact
PSSecure 8.0

fact
NetIQ Security Solutions for iSeries

fact
VigilEnt Security Agent for iSeries

symptom
How do I schedule the Archived User Profiles report ZPQY2601?

symptom
I want to schedule the Archived User Profiles report instead of running the report from the reports menu.

fix

The menu option to run the Archived User Profiles Report can be found using the following path: PSMENU, option 2 (PSSecure), option 2 (Profile & Password Management), option 1 (General Options Menu), option 18 (Archived User Profiles Report). This menu option is limited to a date range with specific dates. The attached source code is for a program that allows you to specify special date values so that the job can be scheduled with the "soft-coded" dates.

1. Save the linked file to the root directory of the local drive (C:\) on your PC.

   https://download.netiq.com/kb/files/ZPCL2601C.txt

2. Copy the file from the PC to the iSeries using FTP:
   1. Open a new DOS or command window.
   2. Type the following command substituting the name of the iSeries server for [system name].  The iSeries IP (internet address) can be used instead of the system name. 

      FTP [system-name]

   3. Type a user ID at the FTP prompt, press Enter.
   4. Type the password at the FTP prompt, press Enter.
   5. Type the following FTP commands:

      put c:\ZPCL2601C.txt  QGPL/QCLSRC.ZPCL2601C

      quit

3. To implement this program, run the following commands:

   CHGPFM FILE(QGPL/QCLSRC) MBR(ZPCL2601C) SRCTYPE(CLP) TEXT('Archived User Profiles Report w/Spcl Date Values')

   CRTCLPGM PSSECURE/ZPCL2601C QGPL/QCLSRC ALWRTVSRC(*NO) AUT(*EXCLUDE)

   CHGPGM PSSECURE/ZPCL2601C USRPRF(*USER) USEADPAUT(*YES) RMVOBS(*ALL)

   CHGOBJOWN PSSECURE/ZPCL2601C *PGM NEWOWN(PSOBJOWN)

   GRTOBJAUT PSSECURE/ZPCL2601C  *PGM REFOBJ(PSSECURE/ZPCL2601)

4. To schedule the Archived User Profiles Report to run daily at 2 AM using the OS/400 Job Schedule, access a command entry screen and run the following command:

ADDJOBSCDE JOB(ZPCL2601C) CMD(CALL PGM(PSSECURE/ZPCL2601C) PARM('*CURR' '*CURR')) FRQ(*WEEKLY) SCDDATE(*NONE) SCDDAY(*ALL) SCDTIME(020000) RCYACN(*SBMRLS) JOBD(PSCOMMON/PSJOBD) JOBQ(*JOBD) USER(*CURRENT) MSGQ(*USRPRF) TEXT('Archived User Profiles Report')

Program ZPCL2601C allows the following special date values for parameter 1 (From date) and parameter 2 (To date):

• *PRVME - Previous month end
• *PRVMS - Previous Month Start
• *PRVWK - Previous week (last 7 days)
• *PRVDY - Previous day
• *CURMS - Current Month Start
• *CURR  - Current Day
• Date   - A valid date value in the MM/DD/YY format

Formerly known as NETIQKB51192