How to get a list of all users with profile records in CA 7 r12 Datacom Database

book

Article ID: 74933

calendar_today

Updated On:

Products

CA Workload Automation CA 7 Edition CA-7 JOB MGMT CA 7 Workload Automation

Issue/Introduction



How can I get a list of users that have a profile record defined to CA 7 r12 Datacom database?

Environment

Release: SEVDT.99000-12.0-Workload Automation-CA 7 Edition
Component:

Resolution

Use the following sample SQL JCL to extract the user profiles from the CA 7 r12 database:
 
jobcard... 
//STEP1 EXEC PGM=DBSQLPR 
//STEPLIB DD DISP=SHR,DSN=your.CUSLIB 
// DD DISP=SHR,DSN=your.CAAXLOAD 
//SYSPRINT DD SYSOUT=* 
//STDOUT DD SYSOUT=* 
//OPTIONS DD * 
PRTWIDTH=255 
INPUTWIDTH=70 
ROWLIMIT=5000 
AUTHID=MFWA 
NOTYPE 
//SYSIN DD * 
SELECT USERID FROM CA7_USER_PROFILE 
WHERE DB = 'logical database name' ; >>>change to your logical db