Technical References

Import_Rule_History Table
This table is in the Blended Agent category (page 439). To see database rules for these tables,
click here (page 503).
Central database only.
Contains the history of every Blended Agent import and shows how many records succeeded
and failed.
Related table
Import_Rule (page 217) (via ImportRuleID)
Table 114: Indexes for Import_Rule_History Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Import_Rule_History
StartDateTime, ImportRuleID, TimeZoneclustered, unique, primary key
located on PRIMARY
XPKImport_Rule_History
Fields in Import_Rule_History Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBINT
The number of records that had errors while importing.
BadRecords
NOT NULLDBDATETIME
The date and time when the import was finished.
EndDateTime
NOT NULLDBINT
The number of records successfully imported so far.
GoodRecords
NULLDBINT
Reserved for future use
FutureUseInt1
NULLDBINT
Reserved for future use
FutureUseInt2
NULLDBINT
Reserved for future use
FutureUseInt3
NULLDBINT
Reserved for future use
FutureUseInt4
NULLDBINT
Reserved for future use
FutureUseInt5
PK, FK NOT NULLDBINT
The current active import.
ImportRuleID
AK-1 NOT NULLDBFLT8
A value used internally by the ICM software to track virtual time.
RecoveryKey
PK NOT NULLDBDATETIME
The date and time when the import was started.
StartDateTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
223
Chapter 2: All Tables
Import_Rule_History Table