I want to reterive all users list with last logon date inculuded(help me with the query)
am running with AS400 iseries system V4R5.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 30, 2008 4:46 PM
UPDATED:
August 10, 2010 1:59 AM
Answer Wiki:
Display User Profiles to an Outfile
DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(MYLIB/USRPRFS)
Create a Query to access MYLIB/USRPRFS and include the field UPPSOD, Previous Sign on Date.
Should be pretty simple,
Bill
==============================================================
Be aware that you need to define "last logon date" before you can be certain. A user profile might "logon" through FTP on a V5R3 system for example, but that logon <b>will not</b> be shown as the 'Previous sign-on' date and time.
There are many ways to "logon". If you want to know if a user profile is in use, you cannot rely on the 'Previous sign-on' date and time.
Tom
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
