25 pts.
 AS/400 – User Profile
Hi; What is the name of the file that stores the value for the "Password verification not valid" field on the User Profile. I created the User Profile file using the DSPUSRPRF command but it shows only a value. I need this information for auditing purpose. Thanks, Ruth.

Software/Hardware used:
AS400 hardaware
ASKED: February 25, 2013  4:27 PM
UPDATED: February 26, 2013  4:31 PM
  Help
 Approved Answer - Chosen by villaflora (Question Asker)

The 'Status' value isn't directly and totally related to the PasswordVerifications value though they can affect each other. A sufficient number of failed verifications can change the 'Status' to *DISABLED if the system is configured for it, but a profile can be disabled in other ways. If a profile's 'Status' is explicitly changed from *DISABLED to *ENABLED, the PasswordVerifications value will also be reset to zero.
 
But those values are "state" values, not audit values. They show current state not an audit trail.
 
If you need to track audit information, you should be processing audit journal entries.
 
Tom

ANSWERED:  Feb 27, 2013  1:24 AM (GMT)  by villaflora

 
Other Answers:
Last Wiki Answer Submitted:  February 26, 2013  4:31 pm  by  Michael Tidmarsh   11,405 pts.
Latest Answer Wiki Contributors:  Michael Tidmarsh   11,405 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


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


 

There is no file that stores the value unless you create one with DSPUSRPRF. The field is supposed to contain a value that is either zero or greater than zero. The field value comes from the *USRPRF object, out of its password verification failures attribute. The attribute is reset to zero as soon as a password is verified for the profile. What would you expect it to contain? — Tom

 108,240 pts.

 

Following is taken directly from the help text for the value in question after pressing F1 on that line of information on an interactive disply of the DSPUSRPRF command.

The number of password verifications that were not valid for the
specified user since the previous successful password verification.
Passwords are verified by sign-on operations, various servers such
as File Transfer Protocol (FTP), and API calls such as Get Profile
Handle (QSYGETPH).

When the password is successfully verified, this field is set to 0.

 645 pts.

 

Well, the bottom is the value I need to explain. I query out the file created using DSPUSRPRF and one user attempt to sign to the system 13 times. This is a cumulative number. How the system tracks the number? Was this done the same day?  and what is odd the account status remain *Enabled.
 
  Password verifications not valid . . . . . :   13
  Status . . . . . . . . . . . . . . . . . . :   *ENABLED

 25 pts.