30 pts.
 Find user profile list who has his audit code is blank or NONE
All, How can we find a user profile (part of audit group) who has his audit code is blank or NONE. Thanks Archie

Software/Hardware used:
ASKED: September 26, 2008  6:51 PM
UPDATED: August 9, 2010  6:32 AM

Answer Wiki:
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
Last Wiki Answer Submitted:  September 29, 2008  4:49 pm  by  WaltZ400   645 pts.
All Answer Wiki Contributors:  WaltZ400   645 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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


 

Create supplementary group and adding user profile to supplement group.

 30 pts.

 

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,725 pts.

 

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

 110,115 pts.