How to get a list of all TPX User Adminstrators along with a list of the TPX groups they can administer?

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

This document is of help if you need to get a list of all User Administrators and the groups these Administrators can administer. The list is compiled by using TPXBATCH.

Background:

Sometimes you need to consolidate and get an overview of who has which rights in TPX. The list of Administrators and their groups is a good inventory to start that consolidation or at least - get an overview.

Instructions:

To get a list of all users who have TPX User Administrator Capability you need to check flag UIDXCADM on 'Y' in UINDEX from the TPXBATCH job

//....     JOB   .....                        
//BATCHADM EXEC  name_of_TPX,VNODE='*BATCH*' 
//EXTFILE  DD    UNIT=SYSDA,SPACE=(CYL,(5,1))
//RPTFILE  DD    SYSOUT=*                     
//SYSIN    DD    *                            
C
EXTRACT GIVING(EXTFILE) USER AND NO SESSIONS (UIDXCADM(Y))            
C
SET RTITLE1                                                           
' USER ADMINISTRATORS WITH GROUPS THEY CAN ADMINISTER'                  
SET RTITLE2                                                           
' USERID    TPX GROUPS'                                               
SET RTITLE3                                                           
' ========  ========'                                                 
C
REPORT GIVING(RPTFILE) USING(EXTFILE)                                 
((' &UIDXNAME ' '&VUSR$MAG                                                                  '))
C
/*

Variable &VUSR$MAG contains all TPX group names the administrator can administer in form of a string.

You need to provide enough space for the display of this variable by setting the single quote after far right.
If you need more than 80 columns for the display due to the number of groups you can put the TPXBATCH SYSIN statements into a dataset with LRECL up to 255.

//SYSIN DD DSN=name_of_dataset,DISP=SHR


This will allow you to display up to 27 groups. If a User Administrator can administer more than 27 groups you only can use TPXADMIN directly to get all groups.

Additional Information:

You find the TPX group names in TPXADMIN in the User Maintenance at Option '6 - Maintain Administrator Capabilities'.