User Profile Information Mining

pts.
Tags:
AS/400
Does anyone have a method for getting information, such as "initial program", from all user profiles on the AS400 in report form? It would be especially if the report could be written to a database file.

Answer Wiki

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

You can execute the DSPUSRPRF command to an output file.

DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE) OUTFILE(QGPL/USERFILE)

The OUTFILE parameter can be changed to whatever file name you want and library you want it to go to. Execute the command using a profile with *ALLOBJ or *SECADM authority. When in doubt do it using QSECOFR. The file you create will contain basic information about every user profile on the system. Initial program and library is included as well as job description, output queue, accounting code, and more. This file can then be queried.

Discuss This Question:  

 
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

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