Cisco Cisco Customer Voice Portal 8.0(1)

•

In the Query menu, type U and Enter to open Notepad. Edit or paste in your query, and save
it if desired. When you click X to close Notepad, the query script is automatically transferred
to Dbaccess.

Access the CVP all-in-one-box server, as administrator, using a tool such as VNC Viewer.

Open a Windows command window: Start > Run.

Enter dbaccess and click OK.

Connect to the cvp_data database:

a.

Press C to select Connection.

b.

Press C again to select Connect.

c.

Select the highlighted database server by pressing <Enter>.

d.

At the USER NAME prompt, enter: cvp_dbadmin and press <Enter>.

Note: The cvp_dbadmin user is created when you install the CVP software.

e.

Enter the password you created for reporting when you installed the CVP software.

f.

At the SELECT DATABASE prompt, use the arrow keys and press <Enter> to select the
cvp_data<hosname> database.

The dashed line below the menu should now show the database name as shown below.

Figure 49: Dbaccess - Connect to the cvp_data Database

Select Exit to back up to the main menu and continue with the next task.

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 CVP 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 U to use an editor as explained at the beginning of 

.

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