Find user profile list who has his audit code is blank or NONE

30 pts.
Tags:
AS/400
AS/400 Query
AS/400 user profiles
All, How can we find a user profile (part of audit group) who has his audit code is blank or NONE. Thanks Archie
ASKED: September 26, 2008  6:51 PM
UPDATED: August 9, 2010  6:32 AM

Answer Wiki

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

You can do a DSPURSPRF on all user profiles to an outfile and query the results. Auditing code is one of the fields in the result file.

Oops. That is DSPUSRPRF.

Waltz,

Whatis that column name, is it “object auditing value” ? or any other field?

Thanks

Discuss This Question: 3  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
  • Archunan
    Create supplementary group and adding user profile to supplement group.
    30 pointsBadges:
    report
  • mcl
    Field names - If you run the DSPUSRPRF to an outfile, then do a DSPFFD on that file. That will give you the field (column) names and a text description of the fields. There are two fields that have to do with "Audit" UPOBJA - "Object Audit Value" UPAUDL - "Action Audit value" As to your question about a "supplementary group". That is just a user profile (account) - typically with a password of *NONE (you don't want people using that account). You add a user to that group by specifying the group on the user profile you are changing under "Supplemental groups". Hope that helps. Regards Mike
    2,740 pointsBadges:
    report
  • TomLiotta
    How can we find a user profile (part of audit group)... What is an "audit group"? Is that meant to ask about a group-profile for which some form of auditing should be done? ...who has his audit code is blank or NONE. What is an "audit code"? As Mcl said, one outfile from DSPUSRPRF has UPOBJA and UPAUDL, both of which relate to auditing. But neither of those would be described as a "code". The most similar seeming user profile attribute that comes to mind would be the "accounting code". Perhaps a description of what is being sought would be useful. 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