Technical References

Trunk Group (page 420) (via TrunkGroupID)
Table 206: Indexes for Trunk_Group_Five_Minute Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Trunk_Group_Five_Minute
DateTime, TrunkGroupID, TimeZoneclustered, unique, primary key
located on PRIMARY
XPKTrunk_Group_Five_Minute
Fields in Trunk_Group_Five_Minute Table:
Keys and Null Option:Data Type:Description:Field Name:
NULLDBINT
Total time, in seconds, during the current half-hour interval that
all trunks in the group were busy.
AllTrunksBusyToHalf
PK NOT NULLDBSMALLDATE
Central Controller date and time at the start of the five-minute
interval.
DateTime
NOT NULLDBINT
Currently not used, set to zero (0).
RecoveryDay
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
PK NOT NULLDBINT
The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
PK, FK NOT NULLDBINT
Foreign key from the Trunk Group table.
TrunkGroupID
NULLDBINT
Number of non-busy trunks in the group at the end of the
five-minute interval.
TrunksIdle
NULLDBINT
Number of trunks in this trunk group in service at the end of the
five-minute interval.
TrunksInService
Trunk_Group_Half_Hour Table
This is in the Device (page 441) category. For database rules, click here (page 504).
Central database only.
Contains information about a trunk group collected during each 30-minute interval.
The ICM software generates Trunk_Group_Half_Hour records for each trunk group.
Related table
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
422
Chapter 2: All Tables
Trunk_Group_Half_Hour Table