Cisco Cisco Customer Voice Portal 8.0(1) Design Guide

Using the new System CLI you can make the request to list log files on the Reporting Server (show 
log). This request includes the Informix Database Server Engine logs. The show tech-support 
command also includes these files.

Debug can now be turned on (or off) from within the System CLI with the debug level 3 (or 0) 
command. When on, this command generates trace files for all administrative procedures, Purge, 
Statistics and Aggregator. Care should be taken when turning this on because the trace files place an 
elevated burden on the database. 

Log data for administrative procedures are now written on a nightly basis to the 
%CVP_HOME%\logs folder.

All StartDateTime, EndDateTime and EventDateTime values are stored as UTC in the various 
Reporting Server tables.

The Reporting Server supports the Analysis Manager tool by allowing Analysis Manager to query 
the Reporting Server as long as the user is authenticated. This user would typically be the 
cvp_dbuser login. 

Transfer Type data and Transfer Labels for SIP and H.323 call events are now stored in the call event 
table.

There is a data aggregator, which aggregates Unified CVP data in fifteen minute increments. Cisco 
Unified Intelligence Center templates are created to capture this information. Call data is 
summarized at 15 minute, daily, and weekly intervals. Dominant Path information is summarized at 
the same intervals. These summaries are stored in the call_15, call_daily, call_weekly, 
applicationsummary_15, applicationsummary_daily, and applicationsummary_weekly tables. Call 
data is summarized into the Call_* structure, while an aggregate of each element invoked by each 
application is stored in the ApplicationSummary_* structures.

To perform a post installation or upgrade of the Reporting Server, you only need to run a single file 
(%CVP_HOME%\bin\CVP_Database_Config.bat). Log in as Informix user and run this file. This 
file is a replacement for the two files used in the past. (ReportingRunAsInformix.bat and 
ReportingRunAsCVP_DbAdmin.bat). This script is run after an installation or an upgrade and is 
designed to upgrade from CVP 4.x or CVP 7.x.

Summary purge results are now logged in the log table.

Three new scheduled tasks have been added or the Reporting Server scheduler.

CVPSummary, which builds summary tables 

CVPCallArchive, which archives Callback data to maintain callback database performance. 

CVPLogDump, which extracts the administrative logs on a nightly basis. 

All metadata for administrative processes has been moved into a new Ciscoadmin database. This 
removes the tables from normal view of reporting users. 

Cisco Unified Intelligence Center templates (CUIC Templates for Reporting Server) are used by 
customers who want to generate user friendly reports on call data stored in the database. 

Please refer to the following guides for more information about the packaged Unified CVP template and 
for information on how to create additional templates:

Reporting Guide for Cisco Unified Customer Voice Portal, available at: