Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
Application_Gateway_Half_Hour
This table is part of the
category. For database rules, see
Central database only. Provides statistics on each Application Gateway.
The software updates these statistics every 30 minutes.
The software generates Application_Gateway_Half_Hour records for each Application Gateway.
Related tables
(via ApplicationGatewayID)
Table 51: Indexes for Application_Gateway_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Application_Gateway_Half_H
DbDateTime
nonclustered located on PRIMARY
XIE1Application_Gateway_Half_H
ApplicationGatewayID, DateTime, TimeZone
clustered, unique, primary key located
on PRIMARY
on PRIMARY
XPKApplication_Gateway_Half_Ho
Table 52: Fields in Application_Gateway_Half_Hour Table
Keys and
NULL
Option
NULL
Option
Data Type
Description
Name
PK, FK
NOT
NULL
NOT
NULL
DBINT
Identifies the Application Gateway.
ApplicationGatewayID
NULL
DBINT
The average response time, in milliseconds, for all
requests to the Application Gateway during the
half-hour interval.
requests to the Application Gateway during the
half-hour interval.
AvgDelayToHalf
PK NOT
NULL
NULL
DBSMALLDATE
The Central Controller date and time at the start of
the interval.
the 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.
are written to the HDS database. The logger database
has NULL for this column.
DbDateTime
NULL
DBINT
Number of errors that occurred for Application
Gateway requests during the half-hour interval.
Consult EMS logs for specific error information.
Gateway requests during the half-hour interval.
Consult EMS logs for specific error information.
ErrorsToHalf
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0
98
All tables
Application_Gateway_Half_Hour