AS/400 User Profile – need to get a file of current user profiles

Tags:
AS/400
Does any one know how to access the file that contains all users profiles or how to create one. I know this is a system file but not sure if we are able to access it. I printed out a listing but I really need a file. Thank you in advance - Gwendolyn

Answer Wiki

Thanks. We'll let you know when a new response is added.

Prompt the DSPUSRPRF command and you will note that you can specify *ALL and further redirect the output to an *OUTFILE

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • Imazing
    All you need to do is do the run this command DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(mylibl/myfile)
    0 pointsBadges:
    report
  • MODMOD
    I use this : DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/USERTEMP) along with some SQL queries to clean up our user file. If you need a more permanent copy of the file put it somewhere other then QTEMP
    0 pointsBadges:
    report
  • ATitus
    That command works great, just remember that it creates an outfile at that point, so if you go back to that file weeks later it will not be a current copy, you would have to do the command again to refresh the data to pick up any changes to the file.
    85 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following