Cisco Cisco Administrative Workstation Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
VNAME32
The system from which the user obtained the lock.
SystemName
NOT NULL
varchar(64)
The name of the user who holds the lock.
UserName
ICR_Node Table
This table is part of the 
Each row represents a real- time distributor associated with an ICM instance. On a Network
ICM, you must configure the distributors associated with each Customer ICM. The Network
ICM needs this information to forward certain configuration changes. Use ICM Configuration
Manager to create, modify, or delete an ICM node.
Related table
(via ICRInstanceID)
Table 108: Indexes for ICR_Node Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1ICR_Node
ICRInstanceID
nonclustered located on PRIMARY
XIE1ICR_Node
ICRNodeID
clustered, unique, primary key
located on PRIMARY
XPKICR_Node
Fields in ICR_Node Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
varchar(255)
Parameters to be passed to the node at initialization.
ConfigParam
NULL
DESCRIPTION
Additional information about the node.
Description
NOT NULL
varchar(64)
The name of the NT domain that contains the node.
DomainName
AK-1 NOT NULL
VNAME32
An enterprise name for the node. This name must be unique for all
nodes in the enterprise.
EnterpriseName
FK, IE-1 NOT NULL
DBINT
The ICM instance associated with the node.
ICRInstanceID
PK NOT NULL
DBINT
A unique identifier for the node.
ICRNodeID
NOT NULL
VNAME32
The host name of the machine on which the node runs.
SystemName
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
214
Chapter 2:  All Tables
ICR_Node Table