5 pts.
 Password Expiration Interval
I have an AS/400 server with hundreds of users. How do I build a complete list of all users whose password expiration interval is set to *NOMAX. The QPWDEXPITV system value is set to *NOMAX. But, I want the list irrespective of QPWDEXPITV parameter. 1 yr down the line, if I change QPWDEXPITV to 90 days even then the query which provides me the list of non-expiring users should be accurate. I will appreciate a prompt and reliable answer. Thank you

Software/Hardware used:
ASKED: May 12, 2009  3:01 PM
UPDATED: October 17, 2009  10:01 AM

Answer Wiki:
Hi, You should be able to use DSPUSRPRF to create an output file :- DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(YOURLIB/YOURFILE) Then you can use Query to select the user profiles with password expiration of *NOMAX. This should be field UPPWEI < 0. If field UPPWEI = 0 then this should use the system value QPWDEXPITV. Regards, Martin Gilbert. ======================================================= You should ignore it and put the effort into removing all of the passwords. Why mess around with them when an EIM/SSO setup makes them obsolete? Tom
Last Wiki Answer Submitted:  October 17, 2009  10:01 am  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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


 

That’s best way – Additional I commonly query these fields as well.
UPINMN Initial menu
UPMXSU Storage used
UPNVSA Sign-on attempts not valid
UPPSOD Previous sign-on date
UPUPDM User profile damaged
UPLTCP Limited capability
UPPRDV Printer device

 365 pts.