CVP Reporting Server

CVP Reporting Server

Database Purging

Default Purge Settings

SQL Reports

All sessions that connect to the reporting database should initiate with two statements:

SET ISOLATION DIRTY READ; SET LOCK MORE TO WAIT 30

This prevents reporting queries from interfering with CallServer message persistence and improves the performance of reporting queries.

Do not ever set the Isolation level to Repeatable Read.
Do not ever write a SQL statement that selects into temp without specifying the 'no log' option.

Connect to DB server via Squirel

Download & Install Squirrel
Download Informix jdbc jar file ifxjdbc.jar and copy to squirrel lib folder - Informix JDBC Driver

JDBC

User: cvp_dbuser
Instance: cvp
Database: cvp_data
Server Address: <cvp-reporting-server>

cvp_data database - ODBC URL

jdbc:informix-sqli://<cvp-reporting-server>:1526/cvp_data:INFORMIXSERVER=cvp

callback database - ODBC URL

jdbc:informix-sqli://<cvp-reporting-server>:1526/callback:INFORMIXSERVER=cvp

Note: The user cvp_dbadmin creates, updates, and owns the database. This user can create and delete reporting users and perform database administrative activities, such as purge and backup. This account should not be used to run the database or to run reports against the system.

Configuring Filters

Note: Changing Filters (on VXML via OAMP) requires a restart of VXML server. Note: regardless of the filter - every call will be inserted into CVP VXML server with the following min vxmlelement enteries:

start
CVP Subdialog Start_01
CVP Subdialog Return_01
end

Filters are separated with a semi-colon “;”, One wild card “*” is supported and can be placed anywhere within each string in the list.

Filter Format (inclusive or exclusive)

ApplicationName.ElementType.ElementName.FieldName

ApplicationName.*.*.SESSION:VarName

Examples

System*.*.*Menu.*;
SystemTestApp.*.MainMenu.*;
SystemTestApp.*.*.SESSION:ServerName

Filter	What It Matches
MyApplication.voice..	Matches all voice elements in MyApplication
.voice..*	Matches all Voice elements in all applications.
MyApplication...var*	Matches all fields in MyApplication that start with with the string var.
MyApplication...*3	Matches all fields in MyApplication that end with 3.
MyApplication...SESSION:Company	Matches the Company session variable in MyApplication.

Example of accessing the informix database via command line

From Command Prompt enter dbaccess
Select Connection → Connect → pick cvp → USER NAME » cvp_dbadmin → provide password → pick callback@cvp → select Exit
Select Query-language → New → and enter the following
```
Select * from queueref
```
hit Escape → select Run

Group Policy

By removing the below highlighted Group Policy (Remove the “Deny local admin users from having network access) (note this is in the Cisco CCE Security Group Policy (CVP doesn't have one) - this fixes the authentication issue. What I cannot understand why it was OK to have this deny setting for CVP 12.0 Reporting server - but it breaks in CVP 12.5 / 12.6 ? So maybe older version uses a local login?,Rather than a network login? (but I would find this odd). Anyway this is what fixed it - and this might be useful for others.

Table of Contents