Hi All,
I am trying to automate pulling some data from moodle database into a data warehouse which is MS SQL Server and I need to use pure MYSQL script and not php, is there a reference for the MySQL scripts behind the actual reports that are generated from moodle?
for example, I want to generate ID, name, course name, date taken, completed/not completed ... etc
thanks alot