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
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...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Thank you! This helped with our audit