I am using the mdl_Logstore_standard_log to create graphs and detailed analysis of pages visited on our system.
However I am seeing multiple log entries for students when visiting pages that are within seconds of each other, which effectively reports that more visits than is actually happening.
i.e. A student lands on our home page, and the log shows that there are three records for the same student going to that page and they are all timed within around 10 seconds, when in fact they have only looked at that page once.
Could anyone explain why this could be please, is this logging when different blocks have been loaded on the page perhaps
I have also included my SQL code to assist
Any assistance would be greatly appreciated.
select mdl_logstore_standard_log. id,
moodle.mdl_course_categories.name as Category,
concat (moodle.mdl_user.firstname, ' ', moodle.mdl_user.lastname) as Who,
from_unixtime(mdl_logstore_standard_log.timecreated) as TheTime
Left join moodle.mdl_course on moodle.mdl_logstore_standard_log.courseid = moodle.mdl_course.id
Left join moodle.mdl_user on moodle.mdl_logstore_standard_log.userid = moodle.mdl_user.id
Left join moodle.mdl_course_categories on moodle.mdl_course.category = moodle.mdl_course_categories.id
(mdl_logstore_standard_log.courseid ='630' or
mdl_logstore_standard_log.courseid ='631' or
mdl_logstore_standard_log.courseid ='610' or
mdl_logstore_standard_log.courseid ='635' or
mdl_logstore_standard_log.courseid ='607' or
mdl_logstore_standard_log.courseid ='581' or
mdl_logstore_standard_log.courseid ='640' or
mdl_logstore_standard_log.courseid ='625') and
(mdl_logstore_standard_log.timecreated > unix_timestamp('2014-10-01 00:00:00') AND
mdl_logstore_standard_log.timecreated < unix_timestamp('2014-10-31 00:00:00')) and
action = 'viewed' and
target = 'course'