Running the ACF2 ACFRPTSL report to filter for a specific date range or character field
Article ID: 26619
Updated On:
Products
Issue/Introduction
How can the ACF2 ACFRPTSL report be ran for a specific date range or search for a specific character field?
The examples below:
- look for a specific date range in either the ACC-DATE or PSWD-TOD date logonid fields
- exclude STC logonids
- show an example of a character field search
Resolution
Using the ACFRPTSL IF (field-name-operators) parameter, a date range can be specified 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 2024:
//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/24' AND ACC-DATE < D'02/01/24' 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/24 (16.067) TIME 10.54 ACFRPTSL SAMPLE REPORT
LOGONID NAME DATE TIME CHANGER PSWD-TOD
USERR01 TEST USERR01 01/27/24-01:53 01/27/24-01:53
USERA01 TEST USERA01 01/22/24-10:02 01/22/24-10:02
USERM01 TEST USERM01 01/29/24-13:40 01/29/24-13:40
USERA02 TEST USERA02 01/07/24-03:07 01/07/24-03:07
USERU01 TEST USERU01 01/22/24-09:58 01/22/24-09:58
USERE01 TEST USERE01 01/04/24-10:54 01/04/24-10:54
USERN02 TEST USERN02 01/21/24-05:06 01/21/24-05:06
USRAN01 TEST USRAN01 01/15/24-22:40 01/15/24-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/24 (16.066) TIME 10.54 ACFRPTSL SAMPLE REPORT
LOGONID NAME GROUP
USERR01 TEST USERR01 TGROUPAdditional Information
Details on the ACFRPTSL report can be found in ACF2 Documentation section ACFRPTSL-Selected Logonid List
Feedback
