100+ ad-hoc contributed mySQL queries to help understand what’s happening on your Moodle site

10547

sqlIf you setup SQL access through PHPmyAdmin or through a program like MySQL Workbench you can directly query your site’s database to extract lots more information than you’ll find available through the admin interface, logs or just as a user looking through the statistics.

Thankfully you don’t have to be a master of SQL to start running reports and pulling information. At Moodle.org there are over 100 queries created by the community that can assist you in extracting harder to get to data from your Moodle. This includes info like how many teachers have logged in lately (or which haven’t), online participation across courses, student interactions, quiz usage in courses by date, and many more.

Check out the full list at https://docs.moodle.org/29/en/ad-hoc_contributed_reports

The following is a list of those shared by Elizabeth Dalton of Granite State University during the iMoot which reminded me of this great resource:

Note the comments in the SQL snippets which will help you to customize them to fit your specific needs.