Disable Launch History Logging

By default, the SCORM Engine will log each launch of a SCORM/AICC package and include information such as launch time, exit time, and completion/score/timetaken at time of exit.  Additionally it contains a log of the runtime API communications.  This information can be valuable when troubleshooting user issues such as times when there's a dispute about whether a course has been completed.  The log data can be valuable as well to Rustici Software support when troubleshooting.

This logging, and the runtime communications data in particular, can take up a significant amount of database storage over time.   For systems that are seeing little value in the Launch History data and are being burdened by excessive storage the following can be done:

Disable ScormLaunchHistory logging via package property for newly imported packages.

This can be accomplished by adding the following override to your Integration class:

// Determines whether to write a ScormLaunchHistory row at all

        public override YesNo DefaultCaptureHistory(LearningStandard learningStandard, bool singleSco, ExternalConfiguration externalConfig)
        {
            return new YesNo(YesNoValue.YES);
        }

 // Determines whether to include the runtime api communications log (this makes up the largest part of ScormLaunchHistory storage)
        public override YesNo DefaultCaptureHistoryDetailed(LearningStandard learningStandard, bool singleSco, ExternalConfiguration externalConfig)
        {
            return new YesNo(YesNoValue.YES);
        }

Disable ScormLaunchHistory for previously imported packages

The best way to do this in bulk is through a simple db query:

-- Determines whether to write a ScormLaunchHistory row at all
update scormpackageproperties set capture_history = 0;

-- Determines whether to include the runtime api communications log (this makes up the largest part of ScormLaunchHistory storage)
update scormpackageproperties set capture_history_detailed = 0;

Delete ScormLaunchHistory data.

Finally, to clear out old data you would simply delete all ScormLaunchHistory rows.  This data is not used at runtime so it will not impact historical registration data.

delete from scormlaunchhistory;