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