CVP Reporting Server

Default Purge Settings

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.

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.

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.

ApplicationName.ElementType.ElementName.FieldName

or

ApplicationName.*.*.SESSION:VarName

Examples

System*.*.*Menu.*;
SystemTestApp.*.MainMenu.*;
SystemTestApp.*.*.SESSION:ServerName
FilterWhat 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.*.*.*3Matches all fields in MyApplication that end with 3.
MyApplication.*.*.SESSION:CompanyMatches the Company session variable in MyApplication.
  • From Command Prompt enter dbaccess
  • Select Connection → Connect → pick cvp → USER NAME » cvp_dbadmin → provide password → pick [email protected] → select Exit
  • Select Query-language → New → and enter the following
  • Select * from queueref
  • hit Escape → select Run
  • vendors/cisco/uc/cvp/reportingserver.txt
  • Last modified: 2022/04/04 09:50
  • by gerardorourke