AS400 command to view all users last login

5 pts.
Tags:
AS/400
AS400 output queue sort search
Output Queues
Hi There,

I need to find a command that will list all users last login. Also all disabled accounts. For Audit purposes

 

Thanks :)

Answer Wiki

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

DSPUSRPRF USRPRF(*ALL)
OUTPUT(*OUTFILE)
OUTFILE(MYLIB/MYFILE)

it will create a Physical file

from this physical file you can get the details.

Discuss This Question: 4  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
  • hafwhit
    You can use the Print User Profile command and it will give you the information you are needing.
    PRTUSRPRF TYPE(*PWDINFO)
    You can prompt the command and select different options but the one above should give you what you want at this time.
    1,145 pointsBadges:
    report
  • Bbogar
    Both DSPUSRPRF USRPRF(*ALL) and PRTUSRPRF TYPE(*PWDINFO) provide lots of info, but there doesn't seem to be any option that gives UID number. Any suggestions?
    15 pointsBadges:
    report
  • TomLiotta
    ...there doesn’t seem to be any option that gives UID number. DSPUSRPRF for an individual profile will display UID on screen. Or DSPUSRPRF *ALL TYPE(*BASIC) to an outfile will include UID for every profile in the output file if you have sufficient authority. It's far out near the end of the record around position 2039. The outfile column heading is USER ID NUMBER. Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    ...a command that will list all users last login... Login to what? Login to the database? To a telnet session? To the remote command server? To something else? There are lots of ways to log in. The user profile value tracks telnet, but it won't tell you if the user did a database login nor most of the others. 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