Cisco Cisco IPCC Web Option Technical References

Page of 404
 
2-67
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Config_Message_Log Table
Related tables:
Class List (via ClassID)
Object List (via ObjectType + ObjectID)
Config_Message_Log Table
Central database only.
A database system table used to store configuration messages.
Controller_Time Table
A database system table that stores the current time at the ICM platform.
Table 2-48 Config_Message_Log Table
Field Name
Description
Data Type
Keys and Null 
Option
RecoveryKey
A value used internally by the ICM software to track 
virtual time.
float
PK, NOT NULL
LogOperation
The type of configuration change. Examples include 
"Add" and "Update".
varchar(32)
NULL
TableName
The name of the table affected by the configuration 
change.
varchar(32)
NULL
DateTime
The date and time when a set of messages was logged.
datetime
NOT NULL
ConfigMessage
All configuration messages in a transaction.
image
NULL
Table 2-49 Controller_Time Table
Field Name
Description
Data Type
Keys and Null 
Option
NowTime
The most recently reported time from the Central 
Controller.
datetime
NULL
TimeZone
The time zone for the device. The value is the offset in 
minutes from GMT.
int
NULL
TimeZoneName
The name of the time zone.
varchar(255)
NULL