Easy way to list all courses with no enrollments

Re: Easy way to list all courses with no enrollments

by Randy Thornton -
Number of replies: 0
Picture of Documentation writers
Kristinn,

I wrote a query some time ago that tries to help with this. The code is here: https://docs.moodle.org/38/en/ad-hoc_contributed_reports#Least_active_or_probably_empty_courses. You can run this using either the Ad-hoc queries plugin (https://moodle.org/plugins/report_customsql) or the Configurable Reports plugin (https://moodle.org/plugins/block_configurable_reports).

It shows courses with:

- 3 or less users (so probably no real student enrolments)
- or that was created but never modified in any way (an empty shell never used )
- or modified but only within the first 60 days (maybe worked on but never used by students)

Course with no enrolments at all will be in this report. There is a column that shows the number of enroled users.


Do you remove all the enrolments from old courses on your system? Or only remove the students and leave the teachers? Either way, this report may help you.


Randy
Average of ratings: Useful (1)