Home > IT Answers > AS/400 > Userprofiles with creation date
Syedm
180 pts.
 Userprofiles with creation date
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

Software/Hardware used:
ASKED: December 17, 2008  4:25 PM
UPDATED: February 27, 2009  2:14 PM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by Syedm (Question Asker)

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.

ANSWERED:  Feb 27, 2009  2:11 PM (GMT)  by Syedm
 
Other Answers:

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

Last Wiki Answer Submitted:  February 27, 2009  2:14 pm  by  philpl1jb   44,070 pts.
Latest Answer Wiki Contributors:  philpl1jb   44,070 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Syedm
 180 pts.