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.
Average Rating
5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
One thought on “iSeries User Profiles Report”
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
More Stories
F986110.JCPRTQ Is Not The Print Queue
In the F986110, the JCPRTQ (Data Dictionary = Print Queue) column is used to store the port number of the JDE services running on the execution host.
JDE CNC + JDE Developer ≠ 1
Recently, while scrolling on this platform, where we all strive to present our best professional selves, I came across a job posting titled JD Edwards E1 CNC/Developer. To be honest, it kind of scared me.
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…
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...
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.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
Thank you! This helped with our audit