TShippen
Community Member

Retrieve fields from User Course Access Log report

Jump to solution

I'm looking to create a report that queries all the content types and content names across all our Canvas courses. The User Course Access Log has these two fields (Content Type and Content) and I'm looking to access them not necessarily by user but by course so I can see a list of all the different types of content our instructors have used in their courses. The User Course Access Log only pulls user data from within one month, so Content only appears on that report if it has been accessed by a user within the last month (at least to my understanding).

Ideally I would get the Course ID, Term, Content, and Content Type. It would be amazing if it could also include the page clicks somehow, though I imagine that's tied to the Users and not the Course/Content itself. 

Does anyone have any recommendations on how to pull this information?  Thank you in advance for any help!

Labels (4)
0 Kudos
1 Solution
jerry_nguyen
Community Contributor

@TShippen 

If you don't need real-time data then you can pull this from Canvas Data

Canvas_Data_Student_Activities.jpg

View solution in original post

0 Kudos
2 Replies
jerry_nguyen
Community Contributor

@TShippen 

If you don't need real-time data then you can pull this from Canvas Data

Canvas_Data_Student_Activities.jpg

0 Kudos

This is absolutely perfect, thank you so much!

0 Kudos