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
    • You do not have permission to view this page - please try signing in.

    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