Cisco Cisco IP Contact Center Release 4.6.1 Technische Referenzen
Network_Trunk_Group_Half_Hour Table
category. For database rules, click
Central database only.
Provides statistics for each network trunk group defined in the system. These statistics are
updated every 30 minutes.
updated every 30 minutes.
The ICM software generates Network_Trunk_Group_Half_Hour records for each network trunk
group.
group.
Related table
(via NetworkTrunkGroupID)
Table 127: Indexes for Network_Trunk_Group_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Network_Trunk_Group_Half_H
DbDateTime
nonclustered located on PRIMARY
XIE1Network_Trunk_Group_Half_H
NetworkTrunkGroupID, DateTime,
TimeZone
TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKNetwork_Trunk_Group_Half_Ho
Fields in Network_Trunk_Group_Half_Hour Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Total number of seconds for which all trunks in
the network trunk group were busy simultaneously
during the half-hour interval.
the network trunk group were busy simultaneously
during the half-hour interval.
AllTrunksBusyToHalf
NULL
DBINT
Number of calls to the network trunk group that
were abandoned during the half-hour interval.
were abandoned during the half-hour interval.
CallsAbandonedToHalf
NULL
DBINT
Number of inbound calls offered to the network
trunk group during the half-hour interval.
trunk group during the half-hour interval.
CallsInToHalf
NULL
DBINT
Number of outbound calls sent on the network
trunk group during the half-hour interval.
trunk group during the half-hour interval.
CallsOutToHalf
PK NOT NULL
DBSMALLDATE
The date and time at the start of the half-hour
interval.
interval.
DateTime
IE-1 NULL
DBDATETIME
The current date and time stamp when the records
are written to the HDS database. The logger
database has NULL for this column.
are written to the HDS database. The logger
database has NULL for this column.
DbDateTime
NULL
DBINT
Aggregate number of seconds trunks in the group
were in service during the half-hour interval.
were in service during the half-hour interval.
InServiceTimeToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
201
Chapter 2: All Tables
Network_Trunk_Group_Half_Hour Table