Bug 21007 - Add new patron column for date of last successful login attempt
Summary: Add new patron column for date of last successful login attempt
Status: RESOLVED DUPLICATE of bug 15504
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords: Academy
Depends on:
Blocks:
 
Reported: 2018-06-27 15:59 UTC by Cab Vinton
Modified: 2023-10-02 20:33 UTC (History)
4 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Cab Vinton 2018-06-27 15:59:16 UTC
The (deleted)borrowers tables includes a column for failed login attempts (login_attempts).

A similar column for date of last successful login would help libraries identify which patrons are & are not taking advantage of the extra features available through their personal accounts.
Comment 1 Cab Vinton 2018-06-27 16:23:24 UTC
I just noticed that there is a lastseen column, but it's not clear to me what this is supposed to track.

A report I ran in our system shows 5,900 null values & 250 '0000-00-00 00:00:00' values.
Comment 2 Magnus Enger 2020-12-16 08:17:36 UTC Comment hidden (obsolete)
Comment 3 Magnus Enger 2020-12-16 08:17:42 UTC
I think this is covered by bug 15504?
Comment 4 Cab Vinton 2020-12-16 11:50:51 UTC
I think you may be right again, Magnus. A lot depends on how Bug 15504 is resolved. Ideally, there will be enough granularity to help librarians distinguish between OPAC logins & SIP2 authentications, for example.

OK to mark this as a duplicate if you feel that is the best route.

Thank you.
Comment 5 Katrin Fischer 2023-10-02 20:32:33 UTC

*** This bug has been marked as a duplicate of bug 15504 ***
Comment 6 Katrin Fischer 2023-10-02 20:33:03 UTC
Note: you can also log successful logins in action_logs.