Cisco Cisco IP Contact Center Release 4.6.2 Technical References

This section provides instructions for creating a template that retrieves real-time data from the Admin 
Workstation database for several selected peripheral services. It employs a SQL statement with a single 
retrieval argument and presents the results as a 3D Pie Chart.

The completed template produces a report that looks similar to the following example.

For each service, this template shows two pieces of information from the tables in the Distributor Admin 
Workstation database: 

The box on the left shows the category, or subject of the report template. The category identifies the 
entities for which the template will retrieve data. In this example, the category is Enterprise Name 
(from the 

Service

 table).

Calls Offered (from the 

Service_Real_Time

 table) is the value displayed for each entity.

Set as Working Library

icm\<icm_instance_name>\aw\custom\persvc\ppb
050.pbl

Presentation Style

Graph

Tables

Service

Service_Real_Tim

e

Table Columns

Service.EnterpriseName

Service_Real_Time.CallsOfferedHalf