Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Last login date for particular staff user

    Last login date for particular staff user

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Desired Outcome Goal:
    * Staff user records contain the date when the staff member's userid/password was last used. (Currently, they do not.)

    Procedure:
    * Add the line "PASSWORD-NO-USE-PERIOD=365" to the $alephe_tab/tab100.
    * Restart the pc server.

    This will cause the z66_last_login_date to be populated for all subsequent log-ins. (Note: There is no way to make this function retroactively for previous log-ins.)

    Additional Information

    * As described in KB 16384-24324 ("Z66_LAST_LOGIN_DATE and PASSWORD-NO-USE-PERIOD "), the Z66_LAST_LOGIN_DATE is populated only when the tab100 PASSWORD-NO-USE-PERIOD is not zero.

    * The xxx50 tab100 has no PASSWORD-NO-USE-PERIOD parameter -- and thus is defaulting to 0. Therefore, the XXX50 Z66_LAST_LOGIN_DATE's are all zero.

    * The staff-02 report ("Staff user report") didn't provide the needed information.

    *  The staff-02 report has no info on the last-login-date; the last-login-date can be checked in the Staff Privileges -- Modify User

     

    There's no Aleph report which reads the z66_last_login_date.  You'd need to that with SQL, such as the following:

    SQL> select z66_rec_key, z66_name, z66_last_login_date from z66;

     

    Category: Staff privileges (500)

     

     


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Last header change" date does not accurately reflect change-date
      • last_result_set and last_request_number SEQ's needed in bib library
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 21
      2. contype:kba
      3. Prod:Aleph
      4. Staff privileges (500)
      5. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved