McDewey

The PurgeHistory table records the history of purge information for both manual and scheduled purges. Table 53: PurgeHistory Table Fields Storage Description Field Name int NOT NULL Primary Key Unique identifier that is assigned to each server in the cluster. nodeId int NOT NULL Primary Key Sequence numbers. purgeHistoryId nvarchar(10,0) NOT NULL PurgeType MANUAL or SCHEDULED. purgeType nvarchar(30,0) NOT NULL PurgeState can be any one of, RUNNING, COMPLETED_SUCCESSFULLY, COMPLETED_WITH_ERRORS,UNKNOWN. purgeState datetime year to fraction(3) NOT NULL Purge start time. purgeStartedDateTime int NULL Historical db size before purge which has the value using store procedure getDbSize with column name as "used”. hrDbSizeBeforePurge datetime year to fraction(3) NULL Date and time of the oldest record before the purge, in YYYY-MM-DD HH:MM:SS.MS format. oldestRecDateTimeBeforePurge datetime year to fraction(3) NULL Purge completion time, in YYYY-MM-DD HH:MM:SS.MS format. purgeCompletedDateTime int NULL Historical db size before purge which has the value using store procedure getDbSize with column name as "used”. hrDbSizeAfterPurge int NULL Config db size before purge which has the value using store procedure getDBspaceUsage('db_cra') with column name as "used". configDbSizeAfterPurge datetime year to fraction(3) NULL Date and time of the oldest record after the purge, in YYYY-MM-DD HH:MM:SS.MS format. oldestRecDateTimeAfterPurge Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 77 Database Schema PurgeHistory