How to get information about your users' profiles

Kenneth Graap, Search400.com expert

Kenneth Graap

Have you ever wanted to find out which users have not signed on in the past 90 days or how many users are on the system? This tip will show you how to get all kinds of information about your user profiles.

Create an OUTFILE of all user profiles defined to the system using the DSPUSRPRF command:


Use the "Display File Filed Description" command to see the field names available in the yourlib/usrprf OUTFILE:


Start getting answers to your questions by analyzing this OUTFILE.

You can see how many total user profiles exist on your system by looking at how many records are in the yourlib/usrprf file. Use the "Display File Description" command:


To determine who hasn't signed on in the past 90 days, use SQL or the iSeries Query Utilities (STRQRY) to query the yourlib/usrprf OUTFILE:

Select fields: UPUPRF (User Profile Name) UPPSOD (Previous sign-on date: YYMMDD)

Sort on UPPSOD in ascending order. This will list all the user profiles in the order of the previous sign-on.

More information

Note: If UPPSOD is "blank," then this user profile has never signed on.

Use query or SQL to answer just about any question you might have about user profiles on your system. All the data you need is now at your fingertips, in the OUTFILE yourlib/usrprf.

About the author: Kenneth Graap is a senior AS/400e system administrator at Northwest Natural Gas in Portland, Ore. He has extensive experience in all aspects of iSeries systems management. That includes proactive performance tuning, system software upgrades and maintenance, hardware upgrade planning, backup/recovery procedures and security.

This was first published in May 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.