Guest

Cisco Unified Intelligent Contact Management Enterprise

Gateway Node and Application Gateway Half Hour Table

Document ID: 52928



Contents

Introduction
Prerequisites
      Requirements
      Components Used
      Conventions
Gateway Node and the Application Gateway Half Hour
NetPro Discussion Forums - Featured Conversations
Related Information

Introduction

This document describes the relationship between the Gateway node of the Script Editor and the Application Gateway Half Hour table in a Cisco Intelligent Contact Management (ICM) environment.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

  • ICM

  • Cisco WebView

  • Microsoft Structured Query Language (SQL) Server

Components Used

The information in this document is based on these software and hardware versions:

  • ICM

  • WebView

  • SQL Server version 6.5 or 7.0

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

Refer to Cisco Technical Tips Conventions for more information on document conventions.

Gateway Node and the Application Gateway Half Hour

The Gateway node of the Script Editor passes ICM data to an external application and receives data in return for use in routing decisions. The Application_Gateway_Half_Hour table stores related statistics on each application gateway. The table stores all the transactions that are transferred to the application gateway through the Gateway node. ICM updates these statistics every 30 minutes and generates Application_Gateway_Half_Hour records for each application gateway.

Issue this SQL command in SQL Query Analyzer in order to display the Application Gateway Half Hour data:

select * FROM Application_Gateway_Half_Hour where DateTime > '2002-10-26'
and ApplicationGatewayID =5005
order by DateTime

Here is the result:

Figure 1: Application Gateway Half Hour Output

ap-gate-half-hr-1.gif

In ICM version 4.6.2 and earlier, Monitor ICM can display the Application Gateway Half Hour data. Figure 2 shows this display. The Requests and Rejects fields (which the A and B arrows show in Figure 2) match the RequestsToHalf and RejectsToHalf fields (arrows A and B in Figure 1) if both these items are true:

  • The ApplicationGatewayID (Figure 1) and Application Gateway (Figure 2) represent the same gateway.

  • The DateTime field matches in Figure 1 and Figure 2.

Figure 2: Application Gateway Half Hour Status

ap-gate-half-hr-2.gif

You can also use WebView in order to display Application Gateway Half Hour data. The table name is apgate11_status_by_half_hour.

When you run Monitor ICM, you can view the real-time statistics of the Gateway node. Arrows A and B in Figure 3 show these statistics.

Figure 3: Script Editor Monitor

ap-gate-half-hr-3.gif

Before you configure a Gateway node in a script, you must define the external application as an application gateway in Configure ICM.

When you configure the No Reply option in the Gateway node, you affect the communication between the Gateway node and ICM. The C arrow in Figure 3 shows the No Reply option. If you set No Reply in the Gateway node, execution continues immediately through the successful terminal of the Gateway node. The external application does not return data to ICM. If you do not set No Reply, the ICM waits for the application to return the data before it completes the script execution. The external application returns data to ICM.

If the application responds before the timeout for the connection, control passes through the successful Gateway node terminal. If the application does not respond before the timeout, control passes through the failed terminal of the Gateway node.

The No Reply option only affects the script behavior. The external must return a response to ICM, but the router does not wait. The appgw process continues to expect the replies. But because the reply does not go to the router, the statistics do not count the reply.

NetPro Discussion Forums - Featured Conversations

Networking Professionals Connection is a forum for networking professionals to share questions, suggestions, and information about networking solutions, products, and technologies. The featured links are some of the most recent conversations available in this technology.
NetPro Discussion Forums - Featured Conversations for Customer Contact Software
IP Communications and Video: Contact Center

Related Information



Updated: Sep 16, 2005Document ID: 52928