20 pts.
 AS400-Who created a user profile
Is there a report on the AS400 that will show who created a user profile.

Software/Hardware used:
ASKED: September 14, 2009  4:54 PM
UPDATED: October 16, 2009  4:23 PM

Answer Wiki:
This was asked last week, here are the multiple answers: http://itknowledgeexchange.techtarget.com/itanswers/user-profile-creation-date-time/ _______________________ If you do a dspobjd of the *USRPRF, it will show you who created the object. If you want it in a report,, then you can do DSPOBJD to an OUTFILE and run a program/qry/SQL over that file.
Last Wiki Answer Submitted:  September 15, 2009  4:25 am  by  CharlieBrowne   33,695 pts.
All Answer Wiki Contributors:  CharlieBrowne   33,695 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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


 

Also, you can use output as *print with detail *full. That’s the way you can print any specific user profile all details or all users details.

Syed

 110 pts.

 

You can also use the CPYAUDJRNE command, provided you have journaling turned on.
This is the command we use:

CPYAUDJRNE ENTTYP(CO DO CP) OUTFILE(QAUDIT) +
JRNRCV(*CURCHAIN) FROMTIME(&YESTERDAY) +
TOTIME(&TODAY 000000)

The command will create a file called QAUDIT with a suffix of journal entry type. So, for type CO (created objects) the file will be called QAUDITCO. After the command creates the file, look for records where COOTYP = ‘*USRPRF’. The record will contain who created the profile, date & time it was created, the IP address of the machine that was used to create the profile as well as a wealth of other information.

 5,830 pts.