Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    18

    Post Unanswered: Duration of login?

    Hi everyone,

    I am using DB2 as backend. How to get the difference of login time and logout time.
    (Eg. Login Time = login1 and Logout time = logout1).

    Please do help with the code. What will be the format of the value.

    Thanks in advance.

    Regards,
    Asaad

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    When a user is connected (or logged in, in your terminology) you can capture the connect time.
    You may have to use Connection Event Monitor to capture the disconnect time (log out time)

    Search for "Create event monitors" in the documentation.

    HTH
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •