Profile display

[Lennie Currington]

Would anyone know if there is a display command for profiles to see everyone who would be in a specific PBS group? I am just trying to do a periodic review to make sure that anyone that transfers to a different group gets removed and anyone that might retire also gets removed

[Roderick Woods]

When you say "display command for profiles", what profiles are you referring to? From a CA 7 perspective are you talking about the /PROF command to display the current user profile? 
Please provide info about the profiles you are seeking.

[Lennie Currington]

When I set someone up to a PBS job I use /PROFS,ID=ABCD,R=CA70028. I am wanting to know if there is a way to display everyone in the 0028 group for instance

[Roderick Woods]

That's what I thought you were looking for. You can use SQL to get this information from the CA 7 database. 
See kd article: 74933

Below is the contents of the knowledge document. 

Issue/Introduction:

How can I get a list of users that have a profile record defined to CA 7 r12.0 or 12.1 database?

Cause:

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.0 or12.1 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