iSeries User Profiles Report

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 ?

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

stewart@9rains.com

http://stewartschatz.com

Average Rating

5 Star

4 Star

3 Star

2 Star

1 Star

(Add your review)

One thought on “iSeries User Profiles Report”

Rob says:

July 5, 2016 at 1:57 PM

Thank you! This helped with our audit

Reply

How to Use the CMDKEY Command to Manage Stored Credentials on Windows

The cmdkey command is a Windows utility that lets you create, delete, and manage stored credentials for network authentication. This is particularly useful…

Stewart Schatz

December 24, 2024December 24, 2024

How to Print a Directory Structure Using PowerShell: Step-by-Step Guide

If you need to print out the directory structure and list the files within, this PowerShell script will help you...

Stewart Schatz

June 7, 2024June 14, 2024

Windows God Mode… What!?!

Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.

Stewart Schatz

January 5, 2023October 23, 2023