Need a quick way to find out how long people took to complete their eLearning? Use the following script to get a handy list showing the users, their eLearning records, and how long in seconds they took to complete them.
Script is below:
select u.LastName, u.FirstName, tc.Prefix, tc.Number, tc.Title,
sr.start_date, SUM(rt.total_time_tracked)/100 AS ‘Time Spent(secs)’
from ScormRegistration sr
inner join ScormActivity sa on sr.scorm_registration_id = sa.scorm_registration_id
inner join ScormActivityRT rt on rt.scorm_activity_id = sa.scorm_activity_id
inner join ScormPackage sp on sr.scorm_package_id = sp.scorm_package_id
inner join TrainingCourses tc on sp.training_course_id = tc.id
inner join Users u on sr.user_id = u.ID
WHERE sr.completion_date IS NOT NULL
GROUP BY sr.scorm_registration_id,u.LastName, u.FirstName, tc.Prefix, tc.Number, tc.Title, sr.start_date, sr.completion_date
order by tc.Prefix, tc.Number, tc.Title, u.LastName, u.FirstName,sr.start_date
Tags: completion, eLearning, SCORM
