All logins for all users in a term?

[abunag]

Is there a convenient way (either via reports, analytics, or API) to get a list of all users and all logins in a specific term?  Our retention team wants to not just know the last login, but also how often users are logging in, in an attempt at student retention.

I thought the "Admin Tools -> Logging -> Login/Logout" was promising for an individual user, just not finding a way to actually generate a usable export with all users.

[jerry_nguyen]

@abunag 

The easiest way is to use Canvas Data, this data is available in the pseudonyms table from Canvas Data

However, it only shows the total (since the account was created). If you have a small number of users on your system, you might be able to pull the data for multiple users by creating a program/script that would call this API endpoint for each user: https://canvas.instructure.com/doc/api/authentications_log.html#method.authentication_audit_api.for_...

The API endpoint allows you to input a date range in which you want to get the data.

The flow would be

1. Input the list of users to the script + start/end date (E.g. VBA through Excel)
2. Call the API for each user
3. Save data to a spreadsheet/database. Then you can create your own report.

I might be able to create the script for this next week using a workflow automation tool I described here: https://community.canvaslms.com/t5/Canvas-Developers-Group/Automate-Canvas-with-n8n/ba-p/585337

If you need help setting it up, feel free to send me a PM.

[reynlds]

I rarely have to actually provide credentials to "log on" to my Canvas institution, so you'll have to be more specific on exactly what you're looking for. I looked at that page in the Admin Tools and it's certainly not helpful. We've got a live feed export from both Canvas and Caliper which records actual logon activity for users (I send these to our Splunkcloud for querying). If you're just looking for CD2 data regarding the number of unique users or roles in a term, here is a quick-n-dirty Postgres query (please note that I'm not a DBA and this is certainly not optimized):

SELECT etd.sis_source_id as banner_term, ed."type" as role, count(distinct p.sis_user_id) as users, count(ed.id) as enrollments
FROM canvas.enrollments ed
  JOIN canvas.courses cd on cd.id = ed.course_id
  JOIN canvas.enrollment_terms etd on etd.id = cd.enrollment_term_id
  JOIN canvas.accounts ad on ad.id = cd.account_id
  JOIN canvas.users u on u.id = ed.user_id 
  JOIN canvas.pseudonyms p on p.user_id = u.id
WHERE etd.sis_source_id in ('120238')  --TERM IDs GO HERE
  AND ed.workflow_state in ('active', 'invited')
  AND ed.type != 'StudentViewEnrollment'
GROUP BY etd.sis_source_id, ed."type"