Greetings,
I'm not certain there is a way to do this with an existing report.
You may want to use Canvas Data 2.
My institution has a specific set of Canvas Data 2 data pulled into a local Postgres database at our school. This way I can connect to the database to make queries with SQL.
To find enrollments in a specific course when the information is in a database, the SQL query would be similar to this:
SELECT *
from
canvas.enrollments e
where
e.course_id = 123456 /*courseid you are interested in*/
and e.created_at >= '1/1/2024'
and e.created_at <= '5/1/2024'
The created_at field in the enrollment table is the date the enrollment was created, which is what you are after. The enrollments table does not include a sis user id, user name or email, you will have to join to canvas.pseudonyms to on enrollments.user_id to get this information.
Enrollments could also be filtered to exclude teachers, TAs, designers etc if you only want students.
If you don't have a dev team to pull the data into a database, you can query Canvas Data 2 with API, there is a Python wrapper to make it easier.
