How to get a list of inactive users by date (Canvas API or Canvas Data 2)?

[sanamlimbu]

Hi everyone,

I’m looking for a way to generate a list of users who have been inactive in Canvas since a given date (e.g., no activity in the last year).

• Is there a Canvas API endpoint that can return users who have not had any activity since a specified date?
• Or, is this better done through Canvas Data 2 (using fields like last_activity_at, last_request_at, etc.)?

If anyone has example API calls, SQL queries, or best practices for identifying inactive users at the account level, I’d really appreciate it.

Thanks!

[oneilllj · Accepted solution]

Hi @sanamlimbu 

Depending on your account access, you can run a Zero Activity Report from the settings. This will provide you a report of all students and users where there has been no activity in a course.

The report is accessible through settings --> Reports --> Zero Activity report, the screen image below provides a summary of what information it provides.

You could also try a Last User Access report.

Hopefully this is of assistance.

Kind regards

Jen