Userprofiles with creation date

180 pts.
Tags:
AS/400 user profiles
Query/400
Please can any one provide me the information how to get the report the list of all userprofiles with creation date. Thanks

Answer Wiki

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

DSPOBJD OBJ(*all ) OBJTYPE(*USRPRF) DETAIL(*FULL) OUTPUT(*PRINT)
but this gives a lot more. I would send it to an outfile instead of *print and then
use query to make the report you want.

Phil

////////////////////

Sorry but I think that it will take three steps to get your results.
These can be put into a CL program.
1. DSPOBJD to *print
2. CPYSPLF to copy the printout to a file
3. QRY to show the results

Phil

Discuss This Question: 2  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
  • Syedm
    Dear Phil: Thanks for your help but i need to print in a simple way like columwise (userprofile , created_date) using command " DSPOBJD" Thanks Syed Muneer
    180 pointsBadges:
    report
  • Gilly400
    Hi, Then use DSPOBJD to an output file and use Query to print from the file. Then you can select which fields(columns) you want to be shown. Regards, Martin Gilbert.
    23,730 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