iSeries User Profiles Report
Read Time:30 Sec
I used the process below to get a text file of the iSeries User Profiles that are on our iSeries:
- From the green screen run the following command
DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(
/ ) - Start a SQL session
STRSQL - Type [Shift]-F1
- Choose option 1
- Change the “SELECT output” to 2
- Run an SQL select statement against the file you created in Step 1. The following statement selects all the active User Profiles
SELECT UPUPRF, UPTEXT FROM
/ WHERE UPSTAT '*DISABLED' - Use iSeries Navigator to export the spool file that is created
Found in How can I list users whose status is disabled on AS/400 ?
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Thank you! This helped with our audit