Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
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
half-hour interval.
TrunksIdle
NULLDBINT
Number of trunks in the group in service at the end of the
half-hour interval.
TrunksInService
Trunk_Group_Real_Time Table
This is in the Device (page 441) category. For database rules, click here (page 504).
Local database only.
Contains real time information about each trunk group.
The ICM software generates a Trunk_Group_Real_Time record for each trunk group.
Related table
Trunk Group (page 420) (via TrunkGroupID)
Table 208: Indexes for Trunk_Group_Real_Time Table
index_keysindex_descriptionindex_name
TrunkGroupIDnonclustered, unique, primary key
located on PRIMARY
XPKTrunk_Group_Real_Time
Fields in Trunk_Group_Real_Time Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Total number of seconds during the current half-hour interval that
all trunks in the group were busy.
AllTrunksBusyHalf
NULLDBINT
Total number of seconds since midnight that all trunks in the group
were busy.
AllTrunksBusyToday
NULLDBINT
Number of calls to the trunk group abandoned in queue during the
current half-hour interval.
CallsAbandonedHalf
NULLDBINT
Number of calls to the trunk group abandoned in queue since
midnight.
CallsAbandonedToday
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
424
Chapter 2: All Tables
Trunk_Group_Real_Time Table