Cisco Cisco IPCC Web Option Technische Referenzen
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 128: 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.
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.
during the half-hour interval.
CallsAbandonedToHalf
NULL
DBINT
Number of inbound calls offered to the network trunk group during
the half-hour interval.
the half-hour interval.
CallsInToHalf
NULL
DBINT
Number of outbound calls sent on the network trunk group during
the half-hour interval.
the half-hour interval.
CallsOutToHalf
PK NOT NULL
DBSMALLDATE
The date and time at the start of the half-hour 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.
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.
during the half-hour interval.
InServiceTimeToHalf
NULL
DBINT
Aggregate number of seconds trunks in the group were in use for
inbound calls during the half-hour interval.
inbound calls during the half-hour interval.
InUseInboundTimeToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
241
Chapter 2: All Tables
Network_Trunk_Group_Half_Hour Table