Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Aggregate number of seconds trunks in the group were in use for
outbound calls during the half-hour interval.
InUseOutboundTimeToHalf
PK NOT NULLDBINT
Identifies the network trunk group.
NetworkTrunkGroupID
NOT NULLDBINT
Currently not used, set to zero (0).
RecoveryDay
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
NULLDBINT
Number of idle trunks in the network trunk group at the end of
the half-hour interval.
TrunksIdle
NULLDBINT
Number of in-service trunks in the network trunk group at the end
of the half-hour interval.
TrunksInService
Network_Trunk_Group_Real_Time Table
This is in the Device (page 441) category. For database rules, click here (page 504).
Local database only.
Provides real-time statistics for each network trunk group in the system.
The ICM software generates a Network_Trunk_Group_Real_Time record for each network
trunk group.
Related table
Network Trunk Group (page 239) (via NetworkTrunkGroupID)
Table 129: Indexes for Network_Trunk_Group_Real_Time Table
index_keysindex_descriptionindex_name
NetworkTrunkGroupIDclustered, unique, primary key
located on PRIMARY
XPKNetwork_Trunk_Group_Real_Ti
Fields in Network_Trunk_Group_Real_Time Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Total number of seconds that all trunks in the network trunk group
have been simultaneously busy during the current half-hour interval.
AllTrunksBusyHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
242
Chapter 2: All Tables
Network_Trunk_Group_Real_Time Table