understanding history tables

Understanding history records

show stats for all class tables

EXEC spMFLogTableStats

deleting history A scheduled agent to delete history on a regular basis is created on installation .Check that it is active and set the deletion period.

EXEC dbo.spMFDeleteHistory @DeleteBeforeDate = '2017-01-08 04:52:03'

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