In a non-test deployment, the reporting database administrator creates user accounts for people who need to
run reports to access call data in the Informix DB.
When you ran the setup .bat file, the system created the user cvp_dbadmin. You can use that user or create
a new user. The exercise uses cvp_dbadmin.
To create a user, complete the following steps:
Step 1 From the Operations Console choose Device Management > Unified CVP Reporting Server.
The Find, Add, Delete, Edit Unified Reporting Servers window opens.
Step 2 Select the reporting server by clicking the link in its name field or by clicking the radio button above it and
then clicking Edit.
The Edit Reporting Server Configuration window opens.
Step 3 Select the Database Administration menu in the toolbar, and then select Manage Reporting Users.
The Manage Users window opens, listing the IP address and host name for the currently selected reporting
Step 4 In the Manage Users pane, select Add User.
Step 5 In the Username field, enter the name for the user.
Step 6 In the Password field, enter a password for the new user.
The password must include upper and lower case letters and numbers. See the required exercise dial
numbers and access information you created earlier for the passwords you are using for these exercises.
Step 7 In the Reconfirm Password field, retype the password.
Step 8 In the Database Administrator Password field, enter the Database Administrator password that you established
when you installed the software.
Step 9 Click Add to add the user.
The message User <name> successfully added as a reporting user appears on the screen.
Access cvp_data Informix Database Using Dbaccess
You can use the supplied Dbaccess tool to query the cvp_data Informix database as explained in this task.
Some basic tips for using this character-based tool are:
Your mouse does not work in this tool. Select menus and menu options using the first character of a
menu or option, or, use the cursor arrow keys to make selections.
Press Ctrl-w to obtain help for the specific menu or option currently selected.
Exit an option or a menu level using the Exit selection.
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.
Step 1 Access the all-in-one-box server, as administrator, using a tool such as VNC Viewer.
Step 2 Open a Windows command window: Start > Run.
Step 3 Type dbaccess and click OK.
Step 4 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, type cvp_dbadmin and press Enter.
The cvp_dbadmin user is created when you install the Unified CVP
e) Enter the password you created for reporting when you installed the software.
f) At the SELECT DATABASE prompt, use the arrow keys to select the cvp_data<hostname> database,
and press Enter.
The dashed line below the menu should now show the database name as in the following example.
Step 5 Select Exit to back up to the main menu and continue with the next task.
Query cvp_data Database
This task continues with the use of the Dbaccess tool to create and run a database query.
For detailed information on the reporting, see the Reporting Guide for Cisco Unified Customer Voice
Step 1 From the top-level menu of Dbaccess, press q to select Query-language.
Step 2 Press n to enter a new query (or u to use an editor).
See topics related to accessing the cvp data Informix database using Dbaccess for more information.
Step 3 Enter one of the following queries. Press Esc 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.
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 Subdialog Return_01" which is the end of the
script and shows control returning to the ICM script.
Have UCCX 10.6 loaded and finesse works fine on IE 11 and microsoft edge and works with Firefox but when using chrome when you click on team data or que data nothing loads stays stuck on loading report. Is this a version issue with chrome.
Hello,I am using CCME 8.6 on a cisco 2921 router and I have configure everything correct supposedly, but when I type in the url and sign in, I can see the page, but no sub menus and I cannot click on anything. I have attached what the screens look li...
Need to update a 7925G to firmware version 1.4(3) so I can use with Callmanger 11.5. Callmanager has version 184.108.40.206, but the phone has CP7925G-MFG-F.2.LOADS. The 220.127.116.11 release notes has:Upgrade from Releases Prior to 1.4(3)If your Cisco Uni...
Hello, On weekends we have our helpdesk team with only 1 person on duty. During the week we have multiple people on the call cue. We ran into an issue a few weeks ago where that one agent was on a call, another call came into the cue and was wai...