Cisco Cisco Customer Voice Portal 8.0(1)

Query the cvp_data Database

This task continues with the use of the Dbaccess tool to create and run a database query.

Note: For detailed information on the reporting refer to Reporting Guide for Cisco Unified
Customer Voice Portal.

From the top-level menu of Dbaccess, press 

 to select Query-language.

Press 

 to enter a new query (or 

 to use an editor as explained at the beginning of 

.

Enter one of the following queries. Press 

 when finished entering the query (or if in Notepad,

exit to transfer the text to Dbaccess).

Query #1:  Number of Call: This query shows the total number of calls made. 

Run the query. Make a call and rerun the query to see the call count increment.

Select count(callguid)

From call

QUERY #2: Follow a Call through its Call Studio script:

Run the next query to see basic information about the call; the elementname items

change to reflect the call's progress through the Call Studio script.

Press "N" to display the next set of elements in the progression.

If you are running this query in conjunction with the comprehensive exercise, 

the last element displayed is "CVP Subdialong Return_01" which is the end of the

script and shows control returning to the ICM script.

(a. b. and c. below are "table aliases")

SELECT a.callguid, a.callstartdate, a.dnis, b.appname, c.elementname

  FROM call a, vxmlsession b, vxmlelement c

 WHERE a.callguid = b.callguid

   AND b.sessionid = c.sessionid 

   AND a.callstartdate=today  

Press 

 to run the query.

Getting Started with Cisco Unified Customer Voice Portal Release 8.0(1)