Re: Is there a way to find out what users are on a given primary group profile?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

If James doesn't have the SQL service for this, I can think of one way, 
using PDM and a user option of DSPUSRPRF that uses the *BASIC option to 
an OUTFILE with MBROPT that *ADDs - in the library that has the USRPRFs, 
filter for only that object type, put the user-option on the 1st one, 
press F13, then press Enter - when done, you should have the info for 
all of them - and Grouf profile is in the *BASIC info.

There's always the QGYOLAUS List Authorized Users API - use format 
AUTU0200 to get the group profiles for each user in turn.

HTH
Vern

On 10/5/2020 10:50 AM, Kevin Bucknum wrote:
> select * from qsys2.user_info u where u.group_profile_name = 'XXX';
>
> On Mon, 2020-10-05 at 08:46 -0700, James H. H. Lampert wrote:
>
> Is there a way to find out what users are on a given primary group profile?
>
>
> --
>
> JHHL
>
>
>
> [https://www.medtronsoftware.com/img/MedtronMinilogo.bmp]  Kevin  Bucknum
>                     Senior Programmer Analyst
>                     MEDDATA / MEDTRON
>                     120 Innwood Drive
>                     Covington LA 70433
>                     Local: 985-893-2550
>                     Toll Free: 877-893-2550
>                   https://www.medtronsoftware.com
>
>
>
> CONFIDENTIALITY NOTICE
>
> This document and any accompanying this email transmission contain confidential information, belonging to the sender that is legally privileged.  This information is intended only for the use of the individual or entity named above.  The authorized recipient of this information is prohibited from disclosing this information to any other party and is required to destroy the information after its stated need has been fulfilled.  If you are not the intended recipient, or the employee of agent responsible to deliver it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of these documents is STRICTLY PROHIBITED.  If you have received this email in error, please notify the sender immediately to arrange for return or destruction of these documents.