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