« Back to General Discussion - All Versions

CVP Reporting Filter

Combination View Flat View Tree View
Threads [ Previous | Next ]
CVP Reporting Filter
Answer
4/25/12 4:56 PM
Hi Experts
 
My customer is running into performance issues on the CVP Reporting server due to a huge call volume.
As such, I have been recommended to apply a "Filter" on the CVP server to limit the number of messages being sent to the Reporting server.
 
The customer is curretly only using the following data from the Report DB:
i. Call Reports
ii. Trunk Reports
 
They are NOT using VXML application reporting for their needs. As such, I was hoping to apply a filter that will restrict only very basic Application data to be logged into the Reporting server.
 
I have tried going through the various CVP reporting guides however due to my limited knowledge on CVP applications/elements I am have a hard time creating a filter.
 
I will appreciate if someone can guide me on this.
 
Regards
Deepak
Flag

RE: CVP Reporting Filter
Answer
4/25/12 7:29 PM as a reply to Deepak Gupta.
CVP Reporting Filter:

The easiest thing to do will be to disable logging of Application Details. In the Operations Console, select one of your VXML Servers.
Then go to the Configuration tab.
There are 2 radio buttons on the left side. The 2nd of these buttons is whether to enable or disable Application Details. Just click to Disable, then press Save&Deploy, then reboot the VxmlServer.

The Application Details are the details of which elements execute in Studio, the variables created, the interaction details with the caller. By disabling this, it'll slow the flow of data to the Reporting Server dramatically.
Flag

RE: CVP Reporting Filter
Answer
4/27/12 7:37 AM as a reply to Janine Graves.
CVP Reporting Filter:

The easiest thing to do will be to disable logging of Application Details. In the Operations Console, select one of your VXML Servers.
Then go to the Configuration tab.
There are 2 radio buttons on the left side. The 2nd of these buttons is whether to enable or disable Application Details. Just click to Disable, then press Save&Deploy, then reboot the VxmlServer.

The Application Details are the details of which elements execute in Studio, the variables created, the interaction details with the caller. By disabling this, it'll slow the flow of data to the Reporting Server dramatically.

 
Thanks for the pointer Janine. The idea is not to stop the VXML messages totally - rather it is to mitigate those to a bare minimum/essential messages.
Is there a generic filter for doing this?
 
Thanks
Deepak
Flag

RE: CVP Reporting Filter
Answer
4/27/12 1:26 PM as a reply to Deepak Gupta.
You can set the filters such that you can define what you want to see and exclude what you do not want. Also other option is to create backups on regular basis and purge also so that you can database does not get filled up fast. There are several ways to handle this.
Hemal
Flag

RE: CVP Reporting Filter
Answer
4/27/12 3:01 PM as a reply to Hemal Mehta.
In the Ops Console, for the VXML Server, go to the Configuration tab.
In the right-side column, you can include and then exclude things using the filters.

The filters are a semi-colon separated list.

Each filter looks sort of like an IP address in that there are 4 things separated by a dot with the format Appname.ElementType.ElementName.FieldName or Appname.*.*.SESSION:sessionVariableName.

ElementType is the type of element:
1 Start or End
2 Subdialog_Start
3 Subdialog_Return
4 Decision
5 Action
6 Custom
7 HotLink
8 HotEvent
9 ElementFlag
10 Voice
11 VXMLInsert
12 ReqICMLabel
13 General

FieldName is the column of the Activity Log after tha application name, like 'element', 'interaction', 'data', 'exit', 'end'

Each of the 4 columns can have at most one wild card * each.

I believe that to include only the exit states from Menu elements that start with 'menu' and all Session variables:
Inclusive: *.Voice.menu*.exit;*.*.*.SESSION:*

It's all in the Reporting Guide for CVP.
Flag