75 pts.
 AS/400 User Profile Creation Date & Time
We can find the user profile creation date and time as,

WRKOBJ OBJ(QSYS/USRPRF) OBJTYPE(*USRPRF)

Is the anyother way to find it?



Software/Hardware used:
ASKED: September 9, 2009  8:46 AM
UPDATED: September 14, 2009  4:38 PM

Answer Wiki:
You can use the DSPOBJD command, with the OBJTYPE as *USRPRF and send the output to a physical file. Then, you may use the ODCDAT field to the creation date (in MMDDAA format) and ODCTIM field to the creation time. You can also field ODCRTU to know the user profile that created the profile.
Last Wiki Answer Submitted:  September 14, 2009  4:37 pm  by  Satsho   1,245 pts.
All Answer Wiki Contributors:  Satsho   1,245 pts. , CharlieBrowne   32,945 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

You can also use the DSPOBJD command.

 1,410 pts.

 

If you have auditing turned on you can find User profile creation there. Use DSPAUDJRN or CPYAUDJRN on entry type CP.

 2,250 pts.

 

DSPOBJD OBJ(QSYS/userprofile) OBJTYPE(*USRPRF) DETAIL(*FULL)

If you need to see multiple profiles, send the output to an *OUTFILE instead then you can run a query.

 5,665 pts.

 

You can use the DSPOBJD command, with the OBJTYPE as *USRPRF and send the output to a physical file.
Then, you may use the ODCDAT field to the creation date (in MMDDAA format) and ODCTIM field to the creation time. You can also field ODCRTU to know the user profile that created the profile.

 55 pts.

 

how can i get creation date, time and  state(enable/disable) ussing commands

 10 pts.

 

If state is needed, RTVUSRPRF can be used to get the STATUS(). The creation date & time would still come from the object description, so two separate commands are necessary. Also, a list of objects can be created with DSPOBJD, and a list of user profiles can be built with DSPUSRPRF when multiple user profiles are accessed. The two lists can be joined by the user profile name. There is no single command that will get object attributes and user profile detail attributes at the same time. (You can create such a command if you want one, but there isn’t much use for it.) — Tom

 108,360 pts.