Yes there are multiple ways 🙂
- Manually doing VLOOKUP with Provisioning reports
To get the provisioning reports go to Admin -> Settings -> Reports. Then download the following reports
- Enrollments (This report will show all user enrollments within an account
- Courses (To map course name with Enrollments table using "canvas_course_id")
- Users (To map user name with Enrollments table using "canvas_user_id")
- Getting site-wide data using Canvas Data
Canvas Data 2 allows you to create custom reports. Using Canvas Data, with a single SQL query you can get a list of courses being assigned to all trainers
You might need to contact your CSM to enable Canvas Data 2 for you.
Feel free to send me a PM if you need help setting up Canvas Data 🙂
