Technical References

Central database only.
Provides statistics for each network trunk group defined in the system. These statistics are
updated every 30 minutes.
The ICM software generates Network_Trunk_Group_Half_Hour records for each network trunk
group.
Related table
Network Trunk Group (page 239) (via NetworkTrunkGroupID)
Table 128: Indexes for Network_Trunk_Group_Half_Hour Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Network_Trunk_Group_Half_H
DbDateTimenonclustered located on PRIMARYXIE1Network_Trunk_Group_Half_H
NetworkTrunkGroupID, DateTime,
TimeZone
clustered, unique, primary key
located on PRIMARY
XPKNetwork_Trunk_Group_Half_Ho
Fields in Network_Trunk_Group_Half_Hour Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Total number of seconds for which all trunks in the network trunk
group were busy simultaneously during the half-hour interval.
AllTrunksBusyToHalf
NULLDBINT
Number of calls to the network trunk group that were abandoned
during the half-hour interval.
CallsAbandonedToHalf
NULLDBINT
Number of inbound calls offered to the network trunk group during
the half-hour interval.
CallsInToHalf
NULLDBINT
Number of outbound calls sent on the network trunk group during
the half-hour interval.
CallsOutToHalf
PK NOT NULLDBSMALLDATE
The date and time at the start of the half-hour interval.
DateTime
IE-1 NULLDBDATETIME
The current date and time stamp when the records are written to
the HDS database. The logger database has NULL for this column.
DbDateTime
NULLDBINT
Aggregate number of seconds trunks in the group were in service
during the half-hour interval.
InServiceTimeToHalf
NULLDBINT
Aggregate number of seconds trunks in the group were in use for
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