Hi,
To try and clean up a rather overgrown Moodle instance, I'm trying to get a list of all courses with their instructors. Does anyone know of a SQL query that will do this, or a PHP command (or set of commands) that might help me out?
Thanks.
You could probably do this with the standard Custom reports feature from Site administration > Reports > Custom reports
Is it possible to get the User and Course IDs (ie, the `id` fields from the database tables) in the Custom Reports? The end goal is to be able to remove stale courses and users, and we have scripts that will do that, but they need to be given the DB id fields.
Using Custom Reports, the primary keys are not available. I asked for this functionality in the previous tracker application, and it seems to have vanished. The primary keys are critical data for the administrators.
You will need to use My SQL to create a query for the role = instructor with the course and user ids.
You will need to use My SQL to create a query for the role = instructor with the course and user ids.
Found this in ad-hoc contributed reports - you might need to modify it a little -
https://docs.moodle.org/404/en/ad-hoc_contributed_reports#All_teachers_and_courses
https://docs.moodle.org/404/en/ad-hoc_contributed_reports#All_teachers_and_courses
This looks like a giant step in the right direction. Thanks!
I found the tracker with the request for primary keys https://moodle.atlassian.net/browse/MDL-80356
Consider voting up this tracker to improve the Custom Reports.
Consider voting up this tracker to improve the Custom Reports.