AS400-Who created a user profile

20 pts.
Tags:
AS/400
AS/400 user profiles
iSeries
iSeries User Profiles
Is there a report on the AS400 that will show who created a user profile.

Answer Wiki

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

This was asked last week, here are the multiple answers:

_______________________

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.

Discuss This Question: 4  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
  • abiha6325
    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 pointsBadges:
    report
  • Teandy
    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,860 pointsBadges:
    report
  • chalenger

    Dears,

    Relying on JRNRCV suppose that you reserve these receivers for a long time since the object was ceated, I think created by can give direct anser to our concern...

    Hassan

    455 pointsBadges:
    report
  • TomLiotta
    Although it's technically possible in some cases, it's almost guaranteed that audit journal receivers will not be kept long enough, and the processing of so many entries would likely be prohibitive. Using DSPOBJD over *USRPRF objects to an outfile is far faster and more efficient. That would also be why CPYAUDJRNE would be unsatisfactory, except for short periods of time, e.g., the last two months. -- Tom
    125,585 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