User profiles not associated with group profiles

[maxcrook]

Does anyone know how to display a user profile that is not associated with a user group ?

i.e is there an sql that could output the profile ?
or output all the profiles but any without a group display a blank? either way of doing it let me know.......

Thanks

 

[gpzcrasher]

You could do

DSPUSRPRF USRPRF(*ALL) TYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(MYLIBRARY/MYFILE)

and then interrogate the file with query.

--------------------------------
Rome did not create a great empire by having meetings, they did it by killing all those who opposed them.

 

[maxcrook]

Thanks tried this but we have thousands of profiles so the file grew very quickly so had to kill the dspusrprf.

Also for some reason I had to change the type to *BASIC as it wouldn't let me perform the command over with *ALL.

 

[bwtc]

Try this command:

DSPAUTUSR SEQ(*GRPPRF)

This will display (or print, if you choose *PRINT) all profiles in the system, sorted by group.

The last group listed is "*NO GROUP", which will contain the data that you're interested in.

 

[maxcrook]

Thats brilliant!

Thank you very much, however just created myself a shed load of work!!!!