Technical References

Keys and Null Option:Data Type:Description:Field Name:
NULLDBINT
For a purge operation, the number of rows purged.
RowsPurged
IE-1 NOT NULLDBDATETIME
Date and time the scheduled job executed.
ScheduledAt
NULLDBDATETIME
Time at which the operation started.
StartTime
IE-1 NOT NULLVNAME32
The name of the database table on which the operation was
performed.
TableName
NULLDBFLT8
For a Purge operation, the recovery key of the most recent record
purged.
ToRecoveryKey
Logger_Meters Table
This table is in the System category (page 460). To see database rules for these tables, click here
(page 511).
Central database only.
Contains performance information about the ICM Logger process. One copy of the Logger
process runs on the Central Controller and another runs on each Admin Workstation.
The Logger process on the Admin Workstation creates a new Logger Meters row in the local
database every five minutes. The Logger process on the Central Controller creates a new Logger
Meters row in the central database every five minutes.
Table 119: Indexes for Logger_Meters Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Logger_Meters
DateTime, TimeZoneclustered, unique, primary key
located on PRIMARY
XPKLogger_Meters
Fields in Logger_Meters Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBINT
The number of configuration changes written during the
five-minute interval.
ConfigMessagesTo5
NOT NULLDBINT
Number of data messages received in the five-minute interval.
DataMessagesTo5
NOT NULLDBFLT8
Number of data pages allocated.
DataPagesAllocated
NOT NULLDBFLT8
Number of data pages used.
DataPagesUsed
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
228
Chapter 2: All Tables
Logger_Meters Table