How can I run the ACFRPTSL report for a specific date range for either the ACC-DATE or PSWD-TOD date logonid fields excluding STC logonids? How about character fields?

Document ID : KB000026619
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:  

 How can I run the ACFRPTSL report for a specific date range for either the ACC-DATE or PSWD-TOD date logonid fields excluding STC logonids?  Can character fields be searched too?

 

Answer:  

Using the ACFRPTSL IF (field-name-operators) parameter a site can specify a date range for a specific date field in the logonid record.

The ACFRPTSL report can be run to select logonids based on date fields that fit a specific date range using the IF (field-name-operators) parameter along with the dates specified in the required format.

DATE FORMAT:
D'mm/dd/yy', D'dd/mm/yy', or D'yy/mm/dd' using Numerics with dividing Date field slashes or (which format is used is based on local system option). Use single quotes before and after the date.

The following sample JCL will select logonids for users (no STC) whose last system access date was within the month of January 2008:

//REPORT  EXEC PGM=ACFRPTSL                                       
//SYSPRINT DD SYSOUT=*                                            
//SYSIN    DD *                                                   
 TITLE(ACFRPTSL REPORT)                                           
 INPUT(ACF2)                                                      
 REPORT(SHORT)                                                    
 SFLDS(PSWD-TOD)                                                  
 IF(ACC-DATE >= D'01/01/08' AND ACC-DATE < D'02/01/08' AND NOT STC)
//*

SAMPLE OUTPUT:

************************************************************************
ACF64001 USER REQUESTING REPORT - AUDIT02 -                             
OUTPUT LIMITED TO ACF2 RECORDS WITHIN YOUR AUTHORITY AND SCOPE.         
AUTHORITY: AUDIT USER                                                   
SCOPE: UID(-)  DSN(-)  LID(-)  SCPLIST(-)                               
************************************************************************
     CA-ACF2 Security - ACFRPTSL - LOGONID SUPERLIST REPORT - PAGE    
DATE 03/06/16 (16.067) TIME 10.54 ACFRPTSL SAMPLE REPORT                
    LOGONID  NAME                  DATE   TIME   CHANGER  PSWD-TOD      
                                                                        
    USERR01  TEST USERR01         01/27/08-01:53          01/27/08-01:53
    USERA01  TEST USERA01         01/22/08-10:02          01/22/08-10:02
    USERM01  TEST USERM01         01/29/08-13:40          01/29/08-13:40
    USERA02  TEST USERA02         01/07/08-03:07          01/07/08-03:07
    USERU01  TEST USERU01         01/22/08-09:58          01/22/08-09:58
    USERE01  TEST USERE01         01/04/08-10:54          01/04/08-10:54
    USERN02  TEST USERN02         01/21/08-05:06          01/21/08-05:06
    USRAN01  TEST USRAN01         01/15/08-22:40          01/15/08-22:40

Character Format:
C'characters to search'

The following sample JCL will select logonids for users who have a GROUP with a name of TGROUP.

//REPORT EXEC PGM=ACFRPTSL //SYSPRINT DD SYSOUT=* //SYSIN DD * TITLE(ACFRPTSL REPORT) INPUT(ACF2) REPORT(SHORT) SFLDS(GROUP) IF(GROUP = C'TGROUP') //*

SAMPLE OUTPUT:

************************************************************************
ACF64001 USER REQUESTING REPORT - AUDIT02 -                             
OUTPUT LIMITED TO ACF2 RECORDS WITHIN YOUR AUTHORITY AND SCOPE.         
AUTHORITY: AUDIT USER                                                   
SCOPE: UID(-)  DSN(-)  LID(-)  SCPLIST(-)                               
************************************************************************
     CA-ACF2 Security - ACFRPTSL - LOGONID SUPERLIST REPORT - PAGE    
DATE 03/06/16 (16.066) TIME 10.54 ACFRPTSL SAMPLE REPORT                
    LOGONID  NAME                  GROUP
                                                                        
    USERR01  TEST USERR01         TGROUP

Additional Information:

Details on the ACFRPTSL report can be found in the CA ACF2 for z/OS Reports and Utilities Guide in Chapter 18: ACFRPTSL-Selected Logonid List.