Statistics for active users by institution

Bug #1483963 reported by Robert Lyon
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
Wishlist
Robert Lyon
15.10
Fix Released
Undecided
Unassigned

Bug Description

Needing to record/display when users have logged in better and display this info per institution on admin statistics page

Currently we only record lastlogin and lastlastlogin which is not robust enough to tell us if a user logs in once per month or many times per month.

We need to record when a user logs in every time they successfully do so.

Robert Lyon (robertl-9)
Changed in mahara:
importance: Low → Wishlist
tags: added: nominatedfeature
Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "master" branch: https://reviews.mahara.org/5086

Revision history for this message
Mahara Bot (dev-mahara) wrote :

Patch for "master" branch: https://reviews.mahara.org/5091

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/5086
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/19af23b2b1fdeeb068d8d1d7bfec3500ccc8930d
Submitter: Son Nguyen (<email address hidden>)
Branch: master

commit 19af23b2b1fdeeb068d8d1d7bfec3500ccc8930d
Author: Robert Lyon <email address hidden>
Date: Mon Aug 10 16:01:18 2015 +1200

Bug 1483963 - Better reporting on login activity

Added a tab 'Logins' to site statistics page that contains
how many total logins for an institution and also how many unique
users have logged in during a certain time period - defaults to
previous calendar month

One can get different results by adjusting the url like so
admin/statistics.php?type=logins&start=2014-01-01&end=2015-01-01
if needing to get a different time period

On upgrade it populates the usr_login_data table with the current
lastlogin time for non-deleted users

Currently usr_login_data only records user id and ctime (for login
time) but one could also add more columns tothe table if needing to
record something that happens once per successful login.

Change-Id: If59b207356894eaced7b9977b80d539a28cb7e56
Signed-off-by: Robert Lyon <email address hidden>

Revision history for this message
Mahara Bot (dev-mahara) wrote :

Reviewed: https://reviews.mahara.org/5091
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/612595cf812309d6cdeb8d33d54fb0b88eecca12
Submitter: Son Nguyen (<email address hidden>)
Branch: master

commit 612595cf812309d6cdeb8d33d54fb0b88eecca12
Author: Robert Lyon <email address hidden>
Date: Thu Aug 13 15:25:40 2015 +1200

Bug 1483963 - Adding help file

Explaining how the default time period works and how you can override it

behatnotneeded

Change-Id: I0f94225f6b7869865545f019a616818b9c6a4b0f
Signed-off-by: Robert Lyon <email address hidden>

Changed in mahara:
status: In Progress → Fix Committed
Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "master" branch: https://reviews.mahara.org/5140

Revision history for this message
Mahara Bot (dev-mahara) wrote :

Patch for "master" branch: https://reviews.mahara.org/5158

Revision history for this message
Kristina Hoeppner (kris-hoeppner) wrote :

This feature was sponsored by the New Zealand Ministry of Education. Thank you for the continued support!

Changed in mahara:
status: Fix Committed → In Progress
Revision history for this message
Mahara Bot (dev-mahara) wrote :

Patch for "master" branch: https://reviews.mahara.org/5159

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/5158
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/0fd2c3771e833812148ad9cf6d4ec0956fdf7fdb
Submitter: Robert Lyon (<email address hidden>)
Branch: master

commit 0fd2c3771e833812148ad9cf6d4ec0956fdf7fdb
Author: Yuliya Bozhko <email address hidden>
Date: Thu Aug 20 13:38:11 2015 +0100

Fix upgrade error (Bug 1483963)

behatnotneeded

Change-Id: I22710f30703aa8e8d0c33fe38199c87a796c3622
Signed-off-by: Yuliya Bozhko <email address hidden>

Robert Lyon (robertl-9)
Changed in mahara:
status: In Progress → Fix Committed
Changed in mahara:
status: Fix Committed → In Progress
Revision history for this message
Robert Lyon (robertl-9) wrote :

Hi Kristina,

I believe this bug is fixed now - what is still outstanding?

Cheers

Robert

Revision history for this message
Kristina Hoeppner (kris-hoeppner) wrote :

Patch https://reviews.mahara.org/5159 still needs to be merged.

Revision history for this message
Mahara Bot (dev-mahara) wrote :

Reviewed: https://reviews.mahara.org/5159
Committed: https://git.nzoss.org.nz/mahara/mahara/commit/fea70e8240df73f1a759529bd9d305c71f66e498
Submitter: Son Nguyen (<email address hidden>)
Branch: master

commit fea70e8240df73f1a759529bd9d305c71f66e498
Author: Robert Lyon <email address hidden>
Date: Fri Aug 21 10:46:18 2015 +1200

Bug 1483963: Fixing issue with reorder table column headers

behatnotneeded

Change-Id: Id6d0439b6cef2fa632ba375489bc3e7c2d0f9990
Signed-off-by: Robert Lyon <email address hidden>

Son Nguyen (ngson2000)
Changed in mahara:
status: In Progress → Fix Committed
Robert Lyon (robertl-9)
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.