Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Central database only.

Contains one record of information for each administrative task the ICM software applies to the central 
database. Specifically, this table tracks Purges and Update Statistics operations. These operations are run 
automatically as scheduled jobs.

Contains a single record containing general information about the ICM configuration.

You can use ICM Configuration Manager to modify some fields of the ICR_Globals records.

RecoveryKey

A value used internally by the ICM software to track 
the time the record is created.

float

PK, NOT NULL

ScheduledAt

Date and time the scheduled job executed.

datetime

IE1, NOT NULL

TableName

The name of the database table on which the operation 
was performed.

varchar(32)

IE1, NOT NULL

FunctionName

The operation performed; for example, Purge or 
Update Statistics.

varchar(32)

IE1, NOT NULL

DateTime

The date and time at which the scheduled job was 
submitted.

datetime

IE2, NOT NULL

Retain

For a Purge operation, the number of days records are 
retained. Records older than this are deleted in the 
Purge.

int

NULL

FromRecoveryKey

For a Purge operation, the recovery key of the earliest 
record purged.

float

NULL

ToRecoveryKey

For a Purge operation, the recovery key of the most 
recent record purged.

float

NULL

StartTime

Time at which the operation started.

datetime

NULL

EndTime

Time at which the operation completed.

datetime

NULL

RowsPurged

For a purge operation, the number of rows purged.

int

NULL

CompanyName

Name of the customer.

varchar(32)

NULL

KeepNScriptVersions

Maximum number of script versions to retain 
for each master script. If the value is 0, all 
versions are retained.

smallint

NOT NULL