Technical References

Fields in Script_Queue_Real_Time Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBDATETIME
The data and time at which this data was last updated.
DateTime
PK NOT NULLDBINT
The local script node identifier.
QueueNode
PK, FK NOT NULLDBINT
The ICM identifier of the application path with which this row is
associated.
ScriptID
NULLDBINT
The number of tasks queued at this script node.
TasksQueued
NULLDBDATETIME
The time in queue for the longest task.
TimeInQueue
Script_Real_Time Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
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.
Related tables
Script (page 317) (via ScriptID)
Table 181: Indexes for Script_Real_Time Table
index_keysindex_descriptionindex_name
ScriptIDclustered, unique, primary key
located on PRIMARY
XPKScript_Real_Time
Fields in Script_Real_Time Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBINT
Number of times the script has executed since midnight. For a routing
script, this is the number of calls processed.
Calls
NOT NULLDBINT
CPU time spent processing the script.
CpuTime
NOT NULLDBDATETIME
Central Controller date and time that this data was last updated.
DateTime
NOT NULLDBINT
Elapsed time spent processing the script.
ElapsedTime
PK, FK NOT NULLDBINT
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