How to know login and logout time for 1 month for per user in AS/400

Tags:
AS/400
AS/400 commands
How can I find out the login & logout time for 1 month for per user in AS/400?
1

Answer Wiki

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

1)CPYAUDJRNE ENTTYP(JS)



2) STRSQL



3)  Sample of query that will return the job started/ended info for
interactive jobs:



SELECT date(JSTSTP)as “date”, time(JSTSTP) as
“Time”,     

 JSUSPF, JSJNUM, JSRADR, JSETYP, JSJTYP
FROM              


QTEMP/QAUDITJS WHERE JSETYP in (‘S’, ‘E’) and JSJTYP = ‘I’





Discuss This Question: 6  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.
  • aceofdelts

    Ideal is if you can set the Logout to automatically generate a joblog. Then you can review the joblogs later.

    Note that users rarely opt for the optional joblog on sign-out.

    2,550 pointsBadges:
    report
  • ToddN2000
    Other than that you may get some info by doing a DSPLOG QHST to print. You will be able to go back as far as you log is retaining data.
    132,840 pointsBadges:
    report
  • hunshabbir7
    Yes you can read History Log as suggested by ToddN2000.
    2,900 pointsBadges:
    report
  • ToddN2000
    Will the post showing CPYAUDJRNE work if it's not turned on? Against my suggestions we do not have any journaling turned on last I knew.
    132,840 pointsBadges:
    report
  • Skillset400
    You can display the start and end timing for last 1 month for that particular user as : 
    dsplog period(0000 081114)(2300 091114) job(XXXX) msgid(CP1124 CPF1164) 

    XXXX - username
    150 pointsBadges:
    report
  • ToddN2000
    Check your QHST log size settings!
    Right now with our current settings, DSPSYSVAL SYSVAL(QHSTLOGSIZ), is set to 50,000 lines. We can only go back 6 days. You may need to adjust this if you want to keep one month but it may get quite large depending on the number of jobs daily.
    132,840 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.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: