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

--- Advertisement ---

Post Pages - Post Inline - WIRIS

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 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

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.

One Response

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

The Latest

The eLearn Podcast

--- Advertisement ---

Post Pages - Sidebar 4 - CourseMerchant

--- Advertisement ---

Post Pages - Sidebar 7 - Titus Learning

--- Advertisement ---

Post Pages - Sidebar 5 - Edwiser (RemUI)

Subscribe to our newsletter

Education technology has the power to change lives. 

To get the latest news, information and resources about online learning from around the world by clicking on the button below.