Delete history logging tables

/*
LESSON NOTES
These examples are illustrations on the use of the procedures.
All examples use the Sample Vault as a base
Consult the guide for more detail on the use of the procedures http:\\tinyurl.com\mfsqlconnector
*/
/*
Understanding history records

*/
-- show stats for all history table
EXEC spMFLogTableStats

-- deleting history
EXEC dbo.spMFDeleteHistory @DeleteBeforeDate = '2017-01-08 04:52:03'
-- Setup scheduled agent to delete history on a regular basis

-- Update history show record of each object update to and from M-Files in XML format.  This is the result of the spmfupdatetable
SELECT TOP 10 * FROM dbo.MFUpdateHistory AS muh ORDER BY id DESC
-- use show history to get listing of individual items
EXEC dbo.spMFUpdateHistoryShow
    @Update_ID = 1238,
    @IsSummary = 1, -- show summary
    @UpdateColumn = 0,
    @Debug = 0

    EXEC dbo.spMFUpdateHistoryShow
    @Update_ID = 1238,
    @IsSummary = 0,
    @UpdateColumn = 3, --show content of specific column
    @Debug = 0

-- Errorlog show all system errors
SELECT TOP 10 * FROM mflog ORDER BY logid DESC

-- spmfaudithistory show to the object versions as a result of the spmfaudittable procedure
SELECT TOP 100 * FROM dbo.MFAuditHistory AS mah

-- show summary of specific session
SELECT * FROM dbo.MFvwAuditSummary AS mfas WHERE sessionID = 1