Cisco Cisco Administrative Workstation Referências técnicas
Table 89: Indexes for Event Table
index_keys
index_description
index_name
CentralControllerFileTime
nonclustered located on PRIMARY
XIE1Event
MessageId
nonclustered located on PRIMARY
XIE2Event
RecoveryKey
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKEvent
Fields in Event Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
image
Optional event binary data.
BinData
NULL
VNAME32
The type of message.
Category
IE-1 NOT NULL
DBDATETIME
File Time event was processed at the Central Controller.
CentralControllerFileTime
NOT NULL
DBINT
Time zone at the Central Controller. The value is the offset
in minutes from UTC (formerly called GMT).
in minutes from UTC (formerly called GMT).
CentralControllerTimeZone
NOT NULL
DBINT
Virtual Time event was processed at the Central Controller.
CentralControllerVirtualTime
NOT NULL
DBINT
The customer ID.
CustomerId
NULL
DBINT
Optional event DWORD.
Dword1
NULL
DBINT
Optional event DWORD
Dword2
NULL
DBINT
Optional event DWORD.
Dword3
NULL
DBINT
Optional event DWORD.
Dword4
NULL
DBINT
Optional event DWORD.
Dword5
NOT NULL
DBINT
Message ID from message compiler.
MessageId
NULL
DESCRIPTION
Contents of message.
MessageString
NOT NULL
VNAME32
Name of the process that originated the event.
ProcName
NOT NULL
DBINT
A value used internally by the ICM software to track virtual
time.
time.
RecoveryDay
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used internally by
the ICM/IPCC Enterprise software to track the record.
the ICM/IPCC Enterprise software to track the record.
RecoveryKey
NULL
varchar(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