Hi,
I am curious if it is possible to configure a report that will produce the same user usage information that the user Logs provide.
I am currently using a report that was created by someone who no longer works for my company. I do not know much about writing SQL code. Here is what my current report looks like:
SELECT DISTINCT prefix_course.shortname AS course,prefix_user.username,prefix_user.firstname,prefix_user.lastname,prefix_user.idnumber AS di_userid,prefix_user.department AS di_acctid,action,date_format(from_unixtime(time),'%m/%d/%Y')AS date FROM prefix_log
LEFT JOIN prefix_user
ON prefix_user.id = prefix_log.userid
LEFT JOIN prefix_course
ON prefix_course.id = prefix_log.course
WHERE action IN ('attempt','enrol','view')
AND module = 'course'
ORDER by time DESC
This is a good enough report, but i noticed it does not track past the first course registration point. So if someone was to view the same course page more than once it would not track it, like it does if you view the individual users Log. Is this even possible?
Thank you for any insight anyone can provide!
Chris