Reports: Ad-hoc database queries

Maintained by Tim at Lone Pine Koala Sanctuary Tim Hunt, at the OU (Perry building) Mahmoud Kassaei
This report plugin allows Administrators to set up arbitrary database queries to act as ad-hoc reports. Reports can be of two types, either run on demand, or scheduled to run automatically. Other users with the right capability can go in and see a list of queries that they have access to. Results can be viewed on-screen or downloaded as CSV.
Picture of Marcus Green
Marcus Green
Wednesday, 26 August 2015, 3:17 AM
General comments
This is a mature program that has been around since before Moodle 2.0 and has been downloaded tens of thousands of times. It was created by the UK Open University, who run one of the worlds largest Moodle installations. Because it is supported by the OU it is very likely to be kept up to date with future releases of Moodle. To create new reports you will need to be familiar with the industry standard SQL (Structured Query Language), and for full advantage you will need to understand table joins....

Ad-hoc database queries 2.2.1 for Moodle 2.2

Picture of Gavin Henrick
Gavin Henrick
Friday, 20 January 2012, 1:16 AM
General comments
This admin report provides a way to create completely custom reports by enabling the user to enter in SQL queries which the report engine then runs. Background This module was released for Moodle 1.9 back in October 2009.  It was written by Tim Hunt of the Open University. It was later upgraded for Moodle 2 by Derek Woolhead also of the Open University.  For those unfamiliar with Tim’s work, he is the maintainer of the Quiz activity module in Moodle. It has recently had another nice feature ad...
Is it simple to install? Yes. After downloadined eeded to  extracted the folder and rename to customsql. I uploaded this into the moodle\report  folder of my Moodle site. When it was installed through the notifications page, the plug-in caused no errors and brought up no extra global settings. Is there documentation for it? The plug-ins page has a brief overview on the module. The Moodle Docs page is very detailed with a good number of example reports. There is also a list of 45 other report...