Teaching with Moodle

SQL for custom reporting

Picture of Sreepathy ...
SQL for custom reporting


Our organization needs a report of moodle usage in the following fashion

User level report

User Level Report
Date User name Time spent in moodle between 10am and 5pm (in mins) Total time spent during the date 

Is there any custom sql query for the same? I checked https://docs.moodle.org/34/en/ad-hoc_contributed_reports#Weekly_Student_Online_Participation , but could not find any. 

Environment : Moodle 3.4 / Mysql 5.7 / Windows 2012 R2 ENT / 32GB RAM / 16 Core CPU

Average of ratings: -
Picture of Visvanath Ratnaweera
Re: SQL for custom reporting
Particularly helpful Moodlers
Seen this "Total Hours spent by users in moodle courses"?
Average of ratings: -
Picture of Anatoliy Kochnev
Re: SQL for custom reporting
Plugin developers


please visit www.intelliboard.net. We offer over 100 out of the box reports plus our services allows you to build your own dashboard and reports instantly. We do offer free plans and as part of our premium plans we contribute to Moodle development as official Moodle integrator.

If you need to setup a demo, please feel free to contact me directly or just knock into our chat on the website.

Thanks a lot


Average of ratings: -