Batch Report identifying users Last Access Date

Products

• TPX - Session Management

Issue/Introduction

In TPX what type of report will shows users and their last access date for TPX?

Environment

Release : 5.4

Resolution

 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.

                                                        

Additional Information

The TPX documentation contains extensive detail on Batch Administration and the various reports, updating, extracts that can be done with this facility.