Release : 5.4
The following report could be run to identify users and when they last accessed TPX. This is helpful in identifying users who may no longer need to be defined to
the TPX database. In the example below, uncomment the EZTFILE and RPTFILE if those should go to output files.
//BATCHADM EXEC <YOUR TPX PROC>,VNODE='*BATCH*'
//EXTFILE DD UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(MOD)
//RPTFILE DD SYSOUT=*
//*EXTFILE DD DSN=TPX.USER.EXTFILE,DISP=(,CATLG,KEEP),
//* DCB=(RECFM=FB,LRECL=133,BLKSIZE=13300,DSORG=PS),
//* UNIT=SYSDA,SPACE=(CYL,(10,1))
//*RPTFILE DD DSN=TPX.USER.RPTFILE,DISP=(,CATLG,KEEP),
//* DCB=(RECFM=FB,LRECL=133,BLKSIZE=13300,DSORG=PS),
//* UNIT=SYSDA,SPACE=(CYL,(10,1))
//*
C
C THIS SAMPLE TPX BATCH ADMINISTRATION JOB IS A REPORT
C OF USERS, WHEN THEY LAST ACCESSED TPX, WHEN THEY WERE LAST UPDATED
C AND BY WHO.
C
EXTRACT GIVING(EXTFILE) USER AND NO SESSIONS (UIDXNAME(--------)) << ALL USERS
C
C
SET RTITLE1 ' User ID Last Access Last Updt Updtd By'
SET RTITLE2 ' ----------------------------------------------------------'
REPORT GIVING(RPTFILE) USING (EXTFILE)
(( '&UIDXNAME ' ' &VUSRDACC ' ' &VUSRDUPD ' ' &VUSRLUPD'))
//
&VUSRDACC << The date on which the user last signed on to TPX.
&VUSRDUPD << The date on which the user record was last updated.
&VUSRLUPD << The user ID of the person who last updated the user record.
For further information on Deleting users using Batch Administration, please review:
Delete Users, Profiles, and Sessions
More detail : Batch Variables
The variables on the report starting with a 'V' are considered 'Special Batch Variables'. These can be used for
extracting or reporting. The variables do not correspond to any fields in TPX online administration.
The TPX documentation contains extensive detail on Batch Administration and the various reports, updating, extracts that can be done with this facility.