Our organization needs a report of moodle usage in the following fashion
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
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