Cisco Cisco IPCC Web Option Technical References

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.

Script (via ScriptID)

Each row describes a table from an external database that can be queried from within routing scripts or 
administrative scripts using the optional Gateway SQL feature.

Use ICM Configuration Manager to add, update, and delete Script_Table records.

ScriptID

Foreign key from the Script Table.

int

PK, FK, NOT 
NULL

DateTime

Central Controller date and time that this data was last updated. datetime

NOT NULL

Calls

Number of times the script has executed since midnight. For a 
routing script, this is the number of calls processed.

int

NOT NULL

CpuTime

CPU time spent processing the script.

int

NOT NULL

ElapsedTime

Elapsed time spent processing the script.

int

NOT NULL

ScriptMeters

Internal real time data for the script.

image

NULL

ScriptTableID

A unique identifier for the external table.

int

PK, NOT NULL

EnterpriseName

A name that is unique among all script tables defined in the 
ICM database.

varchar(32)

AK1, NOT 
NULL

AccessType

Indicates how to query data from the table. Currently only 
SQL (1) is supported.

smallint

NOT NULL

SideA

The path of the database table as reached by Side A of the 
ICM Central Controller.

varchar(255)

NULL

SideB

The path of the database table as reached by Side B of the 
ICM Central Controller.

varchar(255)

NULL