Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-133
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Network_Trunk_Group_Real_Time Table
Network_Trunk_Group_Real_Time Table
Local database only.
Provides real-time statistics for each network trunk group in the system.
The ICM software generates a Network_Trunk_Group_Real_Time record for each network trunk group.
Table 2-111 Network_Trunk_Group_Real_Time Table
Field Name
Description
Data Type
Keys and Null
Option
Option
NetworkTrunkGroupID
Identifies the network trunk group.
int
PK, FK, NOT
NULL
NULL
DateTime
The date and time at which the row was generated.
datetime
NOT NULL
AllTrunksBusyHalf
Total number of seconds that all trunks in the network
trunk group have been simultaneously busy during the
current half-hour interval.
trunk group have been simultaneously busy during the
current half-hour interval.
int
NULL
AllTrunksBusyToday
Total number of seconds that all trunks in the network
trunk group have been simultaneously busy since
midnight.
trunk group have been simultaneously busy since
midnight.
int
NULL
CallsAbandonedHalf
Number of calls to the network trunk group that were
abandoned during the current half-hour interval.
abandoned during the current half-hour interval.
int
NULL
CallsAbandonedToday
Number of calls to the network trunk group that were
abandoned since midnight.
abandoned since midnight.
int
NULL
CallsInHalf
Number of inbound calls that have been received on the
network trunk group during the current half-hour
interval.
network trunk group during the current half-hour
interval.
int
NULL
CallsInNow
Number of inbound calls currently in progress on the
network trunk group.
network trunk group.
int
NULL
CallsInToday
Number of inbound calls that have been received on the
network trunk group since midnight.
network trunk group since midnight.
int
NULL
CallsOutHalf
Number of outbound calls that have been sent on the
network trunk group during the current half-hour
interval.
network trunk group during the current half-hour
interval.
int
NULL
CallsOutNow
Number of outbound calls currently in progress on the
network trunk group.
network trunk group.
int
NULL
CallsOutToday
Number of outbound calls that have been sent on the
network trunk group since midnight.
network trunk group since midnight.
int
NULL
InServiceTimeHalf
Aggregate number of seconds that trunks in the network
trunk group have been in service during the current
half-hour interval.
trunk group have been in service during the current
half-hour interval.
int
NULL
InServiceTimeToday
Aggregate number of seconds that trunks in the network
trunk group have been in service since midnight.
trunk group have been in service since midnight.
int
NULL
InUseInboundTimeHalf
Aggregate number of seconds that trunks in the network
trunk group have been used for inbound calls during the
current half-hour interval.
trunk group have been used for inbound calls during the
current half-hour interval.
int
NULL