Cisco Cisco IP Contact Center Release 4.6.1 기술 참조
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.
the central database. Specifically, this table tracks Purges and Update Statistics operations.
These operations are run automatically as scheduled jobs.
Table 117: Indexes for Logger_Admin Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Logger_Admin
TableName, ScheduledAt, FunctionName
nonclustered located on PRIMARY
XIE1Logger_Admin
DateTime
nonclustered located on PRIMARY
XIE2Logger_Admin
RecoveryKey
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKLogger_Admin
Fields in Logger_Admin Table :
Keys and Null Option:
Data Type:
Description:
Field Name:
IE-2 NOT NULL
DBDATETIME
The date and time at which the scheduled job was
submitted.
submitted.
DateTime
NULL
DBDATETIME
Time at which the operation completed.
EndTime
NULL
DBFLT8
For a Purge operation, the recovery key of the earliest
record purged.
record purged.
FromRecoveryKey
IE-1 NOT NULL
VNAME32
The operation performed; for example, Purge.
FunctionName
PK, AK-1 NOT NULL
DBFLT8
A value used internally by the ICM software to track
the time the record is created.
the time the record is created.
RecoveryKey
NULL
DBINT
For a Purge operation, the number of days records
are retained. Records older than this are deleted in
the Purge.
are retained. Records older than this are deleted in
the Purge.
Retain
NULL
DBINT
For a purge operation, the number of rows purged.
RowsPurged
IE-1 NOT NULL
DBDATETIME
Date and time the scheduled job executed.
ScheduledAt
NULL
DBDATETIME
Time at which the operation started.
StartTime
IE-1 NOT NULL
VNAME32
The name of the database table on which the operation
was performed.
was performed.
TableName
NULL
DBFLT8
For a Purge operation, the recovery key of the most
recent record purged.
recent record purged.
ToRecoveryKey
Logger_Meters Table
This table is in the
Central database only.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
188
Chapter 2: - All Tables
Logger_Meters Table