Hi Team, I have reserved packaged ucce twice but never received email with vpn connection details. Thanks, Raza ... View more

Add Reporting User 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: Procedure 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 server. 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. Note 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.     Procedure 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 software. Note 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 Portal . Note Procedure 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. ---- 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 Subdialog 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 ---- --- select * from vxmlsessionvariable where varname='exitstate' and eventdatetime>'2016-05-05 16:00:00.000' order by eventdatetime desc   Step 4 Press r to run the query. Check below links for more details. http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/customer_voice_portal/cvp9_0/configuration/guide/CCVP_BK_GE7EB947_00_getting-started-with-cvp.pdf Page 80 http://www.cisco.com/c/en/us/support/docs/customer-collaboration/unified-customer-voice-portal/116379-trouble-cvp-server-00.html   ... View more

Note: if facing problem, avoid to copy paste these queries. :) 1. Check active scripts select * from Master_Script 2. Check total number of active scripts select count(*)from　Master_Script 3. Check Call records in ICM database (RCD table) using ANI Select * FROM Route_Call_Detail WHERE　 ANI='replacewithNumber' Select * From Route_Call_Detail WHERE ANI LIKE '%replacewithNumber' --WHERE ANI LIKE '%replacewithNumber' AND DateTime > '5/2/2016 8:00:00' SELECT DateTime, Variable9, Variable10, Variable5, Variable6 FROM Route_Call_Detail WHERE ANI Like '%replacewithNumber' --WHERE ANI LIKE '%replacewithNumber' AND DateTime > '5/2/2016 8:00:00' 4. Check Call records in ICM database (TCD table) using ANI Select * FROM Termination_Call_Detail WHERE ANI='replacewithNumber' 5. Check Dialed Number, Call Type and Scripts mappings Select Dialed_Number.DialedNumberString,Dialed_Number.DialedNumberID,Call_Type.EnterpriseName As CalltypeName,Call_Type.CallTypeID, Master_Script.EnterpriseName As ScriptName,Master_Script.MasterScriptID from Master_Script, Call_Type_Map, Call_Type , Dialed_Number_Map, Dialed_Number where Master_Script.MasterScriptID = Call_Type_Map.MasterScriptID and Call_Type_Map.CallTypeID = Call_Type.CallTypeID and Call_Type.CallTypeID = Dialed_Number_Map.CallTypeID and Dialed_Number_Map.DialedNumberID = Dialed_Number.DialedNumberID order by Dialed_Number.DialedNumberString 6. Check Scripts and Skill Groups mappings Select Master_Script.EnterpriseName as ScriptName, Master_Script.CurrentVersion, Script.Version, Skill_Group.EnterpriseName as SkillGroupName From Master_Script Join Script ON Master_Script.MasterScriptID = Script.MasterScriptID Join Script_Cross_Reference SCR ON SCR.TargetType = 2 and SCR.ScriptID = Script.ScriptID, Skill_Group Where Master_Script.CurrentVersion = Script.Version and Skill_Group.SkillTargetID = SCR.ForeignKey and Master_Script.CurrentVersion = Script.Version 7. Check script related configurations using query, Replace text with script name *(Replace with Script Name) SELECT TargetType, 　　　　　　 XR.ScriptID , MS.EnterpriseName as Script, 　　　　　　 SG.SkillTargetID, SG.EnterpriseName as Skill_2,　　 　　　　　　 CT.CallTypeID, CT.EnterpriseName as CallType_7,　　 　　　　　　 ESG.EnterpriseSkillGroupID, ESG.EnterpriseName as EntSkill_9, 　　　　　　 REG.RegionID, REG.EnterpriseName as Region_10, 　　　　　　 R.RouteID, R.EnterpriseName as Route_17,　 　　　　　 MSC.MasterScriptID, MSC.EnterpriseName as MSEntName_20, 　　　　　　 UV.UserVariableID, UV.VariableName as Variable_31,　 　　　　　　 UF.UserFormulaID, UF.EnterpriseName as Formula_32, 　　　　　　 VRU.NetworkVruScriptID, VRU.EnterpriseName as VRU_33, 　　　　　　 ECC.ExpandedCallVariableID, ECC.EnterpriseName as ECC_37　 FROM Script_Cross_Reference XR 　 INNER JOIN ( 　 SELECT iSC.ScriptID AS ScriptID, iMS.EnterpriseName, iMS.CurrentVersion 　　　 FROM Master_Script iMS 　　　　　 INNER JOIN Script iSC ON iSC.MasterScriptID = iMS.MasterScriptID AND iSC.Version = iMS.CurrentVersion -- Plug in your Script name in the next line... 　　　 WHERE (iMS.EnterpriseName LIKE '%Replace with Script Name%') 　　　 GROUP BY iSC.ScriptID, iMS.EnterpriseName, iMS.CurrentVersion) 　　　 MS ON MS.ScriptID = XR.ScriptID 　 left OUTER JOIN Skill_Group SG on SG.SkillTargetID = XR.ForeignKey and XR.TargetType = 2 　 left OUTER JOIN Call_Type CT on CT.CallTypeID = XR.ForeignKey and XR.TargetType = 7 　 left OUTER JOIN Enterprise_Skill_Group ESG on ESG.EnterpriseSkillGroupID = XR.ForeignKey and XR.TargetType = 9 　 left outer join Region REG on RegionID = XR.ForeignKey and TargetType=10 　 left outer join Route R on RouteID = XR.ForeignKey and TargetType=17 　 left outer join Master_Script MSC on MasterScriptID = XR.ForeignKey and TargetType=20 　 left outer join User_Variable UV on UserVariableID = XR.ForeignKey and TargetType=31 　 left outer join User_Formula UF on UserFormulaID = XR.ForeignKey and TargetType=32 　 left outer join Network_Vru_Script VRU on NetworkVruScriptID = XR.ForeignKey and TargetType=33 　 left outer join Expanded_Call_Variable ECC on ExpandedCallVariableID= XR.ForeignKey and TargetType=37 ORDER BY MS.EnterpriseName, XR.TargetType; 　 8. Primary Handled Call Count select Count(CallDisposition) As PrimaryHandledCallCount from Termination_Call_Detail where CallDisposition in (13, 52) and DateTime>='02/09/2016 00:00' and DateTime<='02/09/2016 13:03' 　 　 9. Abandoned in Network Flag Count Select Count(CallDisposition) As AbandonedinNetworkFlagCount from Termination_Call_Detail where DateTime>='02/09/2015 00:00' and DateTime<='02/09/2015 13:17' and CallDispositionFlag = 1 10. Abandoned Delay Count Select Count(CallDisposition) As AbandonedDelayCount from Termination_Call_Detail where DateTime>='02/09/2015 00:00' and DateTime<='02/09/2015 13:29' and CallDispositionFlag = 4 11. Call_Type Count & Enterprise Name / Skill Group Count & Enterprise Name select count(*) from Call_Type select EnterpriseName from Call_Type select count(*) from Skill_Group select EnterpriseName from Skill_Group 12. Retrieve and use Column Tile for values Select  r.DialedNumberString AS [DNIS] ,r.ANI ,r.DateTime ,r.RouterCallKeyDay ,r.RouterCallKey ,r.Variable3 AS [LineOfBusiness1] ,r.Variable4 AS [LineofBusiness2] ,m.EnterpriseName AS [Script Name] FROM pic4_hds.dbo.t_Route_Call_Detail AS r JOIN pic4_awdb.dbo.t_Script AS s ON r.ScriptID=s.ScriptID JOIN pic4_awdb.dbo.t_Master_Script AS m ON s.MasterScriptID=m.MasterScriptID Where r.ANI =''replacewithNumber''AND r.DateTime BETWEEN '2015-12-07 12:56:00'AND '2015-12-07 13:00:0' 13. For Presistent Variable value in Logger (run on Logger Db) select * from Persistent_Variable select * from User_Variable select User_Variable.VariableName, Persistent_Variable.ValueInt, Persistent_Variable.ValueFloat, Persistent_Variable.ValueChar From User_Variable INNER JOIN Persistent_Variable ON User_Variable.UserVariableID = Persistent_Variable.UserVariableID SELECT uv.ObjectType, pv.ValueInt, uv.VariableName, pv.ValueChar FROM Persistent_Variable pv, User_Variable uv WHERE pv.UserVariableID = uv.UserVariableID ORDER BY uv.VariableName DESC ... View more