How to report/list all TPX user ids with last logon date via Batch
Article ID: 411293
Updated On:
Products
Issue/Introduction
Is it possible to list all ids in TPX with the last logon date and also have the total TPX id count via batch?
Environment
Release: 5.4
Component: TPX for Z/OS
Resolution
Note that listing userid's is dependent on userid's being static or save Dynamic.
Dynamic only cannot be listed in the report as there is no userid 'record' in the TPX database.
To list all user ids (static or save Dynamic) including the last logon date, run the following report/extract:
Modify the part marked in RED
//ADD JOBCARD
//*
//* THIS SAMPLE TPX BATCH ADMINISTRATION JOB REPORTS ALL USERS
//* OF TPX WITH THEIR LAST LOGON DATE
//*
//BATCHADM EXEC tpxproc,VNODE='*BATCH*'
//EXTFILE DD DSN=TPX.USER.EXT1,DISP=(,CATLG,KEEP),
// DCB=(RECFM=FB,LRECL=8000,BLKSIZE=15000,DSORG=PS),
// UNIT=SYSDA,SPACE=(CYL,(20,5))
//RPTFILE DD DSN=TPX.USER.RPT1.FILE,DISP=(,CATLG,KEEP),
// DCB=(RECFM=FB,LRECL=8000,BLKSIZE=13300,DSORG=PS),
// UNIT=SYSDA,SPACE=(CYL,(20,5))
//SYSIN DD *
EXTRACT GIVING(EXTFILE) USER AND NO SESSIONS
(VUSRDACC(--------))
SET RTITLE1
' USERID LAST LOGON '
SET RTITLE2
' ======== ======== '
REPORT GIVING(RPTFILE) USING(EXTFILE)
(( ' &UIDXNAME' ' &VUSRDACC' ))
If the total ID count is needed, currently the output does not provide the total number of ids, but it is possible to obtain that by following the options below:
- Option 01: View /Edit the Report (RPTFILE) dataset created by the job above and see the total number of lines.
- Option 02: Download the Report (RPTFILE) into Excel.
- Option 03: Write an extra REXX script to run counter.
Additional Information
Feedback
