Teaching with Moodle

SQL for custom reporting

 
Picture of Sreepathy ...
SQL for custom reporting
 

Hi,

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"?
https://moodle.org/mod/forum/discuss.php?d=371302
 
Average of ratings: -
Picture of Anatoliy Kochnev
Re: SQL for custom reporting
Plugin developers

Sreepathy,

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

Anatoliy

 
Average of ratings: -