TPX batch - example - List all users with a specific profile name

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

Description:

This document shows you how to extract and list the users that have been assigned a specific profile.

Solution:

This example extracts all users with the profile name DUMMY and produces a report showing these userids.

Wildcards can also be used. For example, (ABC----) can be used to get all users with a profile name beginning with ABC.

//BATCH EXEC TPX1,VNODE='*BATCH*'  <== YOUR TPX HERE
//EXTFILE DD UNIT=SYSDA,SPACE=(CYL,(1,1))
//RPTFILE DD SYSOUT=*
//SYSIN DD *
EXTRACT GIVING (EXTFILE) USER AND NO SESSIONS (VUSRPROF(DUMMY)) 
SET RTITLE1                        
' USERIDS with profile DUMMY'   
SET RTITLE2                        
' =========================='   
REPORT GIVING (RPTFILE) USING (EXTFILE)
  ((' &UIDXNAME'))
//