Canvas Data 2 Gradebook activity

WillGHampton
Community Explorer

Greetings,

I'm working on a Canvas Data 2 query I'd like assistance with. The goal is to identify courses where the Canvas Gradebook is not being used. Scenarios I can envision are courses that do not have assignments with gradebook entries or assignments are past their due date with no grade.

Checking the Canvas Data 2 schema, there does not seem to be a table for the gradebook directly. What tables, other than assignment_submissions, quiz_submissions and discussion_entries  could be useful to query to check for gradebook activity?

Thanks

Will Hampton