Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Fields in Script_Queue_Real_Time Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBDATETIME
The data and time at which this data was last updated.
DateTime
PK NOT NULL
DBINT
The local script node identifier.
QueueNode
PK, FK NOT NULL
DBINT
The ICM identifier of the application path with which this row is
associated.
associated.
ScriptID
NULL
DBINT
The number of tasks queued at this script node.
TasksQueued
NULL
DBDATETIME
The time in queue for the longest task.
TimeInQueue
Script_Real_Time Table
This table is part of the
Local database only.
Contains real time information about each script. The ICM software updates the real-time data
each time it executes a script. The Admin Workstation receives updated data every 15 seconds.
The real-time data for current script versions is updated at midnight.
each time it executes a script. The Admin Workstation receives updated data every 15 seconds.
The real-time data for current script versions is updated at midnight.
Related tables
Table 181: Indexes for Script_Real_Time Table
index_keys
index_description
index_name
ScriptID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKScript_Real_Time
Fields in Script_Real_Time Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
Number of times the script has executed since midnight. For a routing
script, this is the number of calls processed.
script, this is the number of calls processed.
Calls
NOT NULL
DBINT
CPU time spent processing the script.
CpuTime
NOT NULL
DBDATETIME
Central Controller date and time that this data was last updated.
DateTime
NOT NULL
DBINT
Elapsed time spent processing the script.
ElapsedTime
PK, FK NOT NULL
DBINT
Foreign key from the Script Table.
ScriptID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
322
Chapter 2: All Tables
Script_Real_Time Table