// Add your reply above here
==================================================
Michael Herring updated this ticket at December 2nd, 2010 @ 09:14 PM
I was recently asked to provide login statistics for our Bricolage users but found the system does not store login/logout events. I had to resort to the apache access log which was a pain. The simplest way to provide basic user stats in Bricolage would be to add the following columns to the usr table:
last_login (timestamp) -> updated after a successful login
login_count (int) -> incremented after a successful login
This would allow an admin to run a basic report showing how often the system is used and by which users.
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/229-add-last_login-and-login_count-columns-to-usr-table
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/projects/29601/tickets/229-add-last_login-and-login_count-columns-to-usr-table/watch
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com
==================================================
Michael Herring updated this ticket at December 2nd, 2010 @ 09:14 PM
I was recently asked to provide login statistics for our Bricolage users but found the system does not store login/logout events. I had to resort to the apache access log which was a pain. The simplest way to provide basic user stats in Bricolage would be to add the following columns to the usr table:
last_login (timestamp) -> updated after a successful login
login_count (int) -> incremented after a successful login
This would allow an admin to run a basic report showing how often the system is used and by which users.
--------------------------------------------------------------------------------
Assigned: Bugs (at bricolage)
State: new
View this ticket online: http://bricolage.lighthouseapp.com/projects/29601/tickets/229-add-last_login-and-login_count-columns-to-usr-table
Stop being notified of this ticket's changes: http://bricolage.lighthouseapp.com/projects/29601/tickets/229-add-last_login-and-login_count-columns-to-usr-table/watch
Update your Profile: http://bricolage.lighthouseapp.com/profile
Support: support@lighthouseapp.com or http://help.lighthouseapp.com