Technical References

Table 89: Indexes for Event Table
index_keysindex_descriptionindex_name
CentralControllerFileTimenonclustered located on PRIMARYXIE1Event
MessageIdnonclustered located on PRIMARYXIE2Event
RecoveryKeyclustered, unique, primary key
located on PRIMARY
XPKEvent
Fields in Event Table:
Keys and Null Option:Data Type:Description:Field Name:
NULLimage
Optional event binary data.
BinData
NULLVNAME32
The type of message.
Category
IE-1 NOT NULLDBDATETIME
File Time event was processed at the Central Controller.
CentralControllerFileTime
NOT NULLDBINT
Time zone at the Central Controller. The value is the offset
in minutes from UTC (formerly called GMT).
CentralControllerTimeZone
NOT NULLDBINT
Virtual Time event was processed at the Central Controller.
CentralControllerVirtualTime
NOT NULLDBINT
The customer ID.
CustomerId
NULLDBINT
Optional event DWORD.
Dword1
NULLDBINT
Optional event DWORD
Dword2
NULLDBINT
Optional event DWORD.
Dword3
NULLDBINT
Optional event DWORD.
Dword4
NULLDBINT
Optional event DWORD.
Dword5
NOT NULLDBINT
Message ID from message compiler.
MessageId
NULLDESCRIPTION
Contents of message.
MessageString
NOT NULLVNAME32
Name of the process that originated the event.
ProcName
NOT NULLDBINT
A value used internally by the ICM software to track virtual
time.
RecoveryDay
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by
the ICM/IPCC Enterprise software to track the record.
RecoveryKey
NULLvarchar(16)
The level of the message.
Severity
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
178
Chapter 2: All Tables
Event Table