Hola Jose David.
Para conocer la actividad del campus se lee el log.
Utilizo de base el siguiente enlace:
https://docs.moodle.org/27/en/ad-hoc_contributed_reports
Y luego adapto a lo que necesito.
Saludos
SELECT DATE_FORMAT( FROM_UNIXTIME( l.TIME ), '%Y-%m-%d' ) AS fecha,
l.userid AS userid, u.lastname AS Apellido, u.firstname AS Nombre
FROM prefix_log AS l
JOIN prefix_user AS u ON u.id = l.userid
JOIN prefix_role_assignments AS ra ON l.userid = ra.userid
JOIN prefix_role AS r ON r.id = ra.roleid
WHERE
ra.roleid IN (3,4) # (3) editingteacher (4) teacher
AND l.TIME > 1451606400 #01/01/2016
AND l.TIME < 1483228800 #31/12/2016
GROUP BY grptimed,l.userid
ORDER BY grptimed desc,
u.lastname, u.firstname