[ARCHIVED] Creating Active User Report

[nchild]

Hello All. How do I run a report to export that shows me all active users by type?

Thank you,

Nikki

[James · Accepted solution]

 @nchild  

In Canvas, "type" of user is called a "role" and they vary depending on course. You can be a teacher in one course and a student in another course. "Active" users could me a couple of different things as well -- there is an "active" status in Canvas and then there is a person who is actively using Canvas (the first kind is easier to find).

You will need to combine reports to get this information. The reports can be found under Admin > Settings > Reports.

The Provisioning Report can get you a list of all of the users, courses, and their enrollments. Start with the enrollments report, which contains the user_id, course_id, role, and status (active, deleted). From there, you can join the data with the users and courses (and perhaps other) files to fill in the missing data. The users report includes the name and SIS ID of the user. The courses report includes the names of the courses and their status.

Here are a couple of documents I wrote that shows some examples of how to combine the data:

• https://community.canvaslms.com/docs/DOC-4629-how-to-list-teachers-who-have-publishedunpublished-cou... 
• Obtaining a list of Admin Users with their Roles 

If by active, you mean those who are showing activity, not just those with active enrollments, then there is another admin report that you can combine with the provisioning report. There is a Last Enrollment Activity report and a Last User Access report that can help here. They don't break it down by the course, though, so you won't be able to tell if John is active in Biology but not Math using them. There is also a Zero Activity report which is by course, but you would want to look for people who aren't found in that list.

[PatriciaFriess]

I am looking for a report to show all users in the system and their status, i.e. active or suspended.