Userprofiles with creation date

Syedm

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

Asked: December 17, 2008 4:25 PM Last updated: February 27, 2009 2:14 PM

Answer Wiki

Last updated: February 27, 2009 2:14 PM GMT

philpl1jb54,090 pts.
History
Contributors
- Ordered by most recent
- philpl1jb54,090 pts.

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

Syedm Feb 27, 2009 8:58 AM GMT

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 Feb 27, 2009 2:11 PM GMT

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