Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Leaflet
Database Schema
Database Table Details
42
Cisco Customer Response Solutions Database Schema
Related Tables
•
(monitoredSessionID maps to sessionID, via
nodeID, profileID)
•
sessionID, sessionSeqNum, nodeID, profileID)
•
(monitoredSessionID maps to sessionID, via
nodeID, profileID)
•
(monitoredSessionID maps to sessionID, via
nodeID, profileID)
•
(origMonitoredID maps to
contactServiceQueueID when origMonitoredIDType is 2, via profileID)
•
(via sessionID, profileID, nodeID,
startMonitoringReqTime)
•
(remoteLoginID maps to loginID, via profileID, rmonID)
Resource
Database table name: Resource
The Cisco CRS system creates a new record in the Resource table when the CRS
system retrieves agent information from the Cisco Unified Communications
Manager.
system retrieves agent information from the Cisco Unified Communications
Manager.
gmtOffset
Offset, in minutes, between local
time of the CRS server and
Greenwich Mean Time.
time of the CRS server and
Greenwich Mean Time.
int
NOT NULL
nodeID
Unique identifier assigned to each
server in the cluster.
server in the cluster.
smallint
NOT NULL
Primary Key
Table 1-14
RemoteMonitoringDetail Table Fields (continued)
Field Name
Description
Storage