Student Group Creator User_ID

I use Canvas flat file data for all manner of reporting within our institution.  I've recently been looking into student groups and one thing I'd like to know is who created the groups.  It...

Student and Resource Weekly Data

Not a question so much as an issue I'd like to raise.  When I looked at weekly activity and selected a particular week the student data was filtered to that week but the resource use data rem...

Quiz Override

I have a request/suggestion..   ASSIGNMENT_DIM has a VISIBILITY field which tells me whether the original version of an assignment is valid to any users following an override or if only the o...

Filtering for Course Q&A Discussion Forums in Canvas Data

I’ve been trying to separate the ‘Course Q&A Discussion Forum’ discussions from the others by using DISCUSSION_TOPIC_TITLE in the DISCUSSION_TOPIC_DIM.  This works in the majority of cases b...

Course Workflow State Changes

Is there a way to find out when a course changed states?  I'd like to know when published courses were published if that was possible.  I'm trying to workout the actual lifespan of cour...

Embedded Video

I'm looking for a way to identify courses within Canvas that have embedded video content.  I've tried using the 'body' field in the wiki_page_dim table but this only shows the first 250 characte...

Multiple Due Date Assignments

I've noticed that assignments with multiple due dates show 'null' in the Due_At column of the Assignment_Dim table.  In my query builder I've joined Assignment_Dim.Assignment_ID=Course_Dim.Assig...

Wiki Page Data

I'm trying to get information relating to all of the wiki pages contained within a course from the Canvas data.  Looking at the wiki and wiki page dimensions I get only 1 wiki per course.  ...

Page View Query

I'm trying to get page view statistics for all students in all courses from the Canvas data and presume that I would need to interrogate the requests table in some way.  So far I haven't been ab...

Is there any way to discern when a course was published (became 'available')?

I'm looking at the Course Dimension table from the Canvas data but can't find this info.  Does anyone know if it is available somewhere?

Active Student Enrollment List

Does anyone know of a way to create a list of active enrolled students at a specific previous date? Thank you in advance for your help.

ECHO360 Exports and Canvas Data

I'm wondering how I can link Echo360 exports csv's with my Canvas data files in a visualisation tool.  The unique values in the export are the Canvas User ID and the Email Address columns. ...

File Count Userscript

I installed Canvas-Files-Get_Files.user.js and Greasemonkey and ran it to count the files in a course.  The result was... This course has these file counts: 217 application/pdf ...

Edited Courses

I'm new to working with this data and wondered where I might find information about which courses have been edited and when.  I'm looking at edits to things like Quizzes, Discussions, Wikis and ...