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