02-10-2015 09:40 AM
I must to create some way to obtain the total calls(IN) over a Cisco CVP solution, this solution(Cisco) is already installed and working properly. But here nobody has any knowledge about cisco CVP.
For this reason, i have no idea for how to get information about every incoming call over this Cisco CVP. Somebody would help me about it?
Does exist some webservice in cisco CVP for consulting that information?
or
Can i create anything over the Cisco CVP for send this information?
Any help is welcome.
Thanks.
03-09-2015 10:36 AM
If you have configured a CVP Reporting server, then you can read that data out of the Call table, or one of the Call summary tables (call_15, call_daily, call_weekly, call_monthly). If you have a CUIC server configured, there are stock reports that will do all of that for you.
Regards,
Jack Parker
03-09-2015 10:50 AM
Antraxa,
It depends on what you need to find out.
If you only need to find out how many calls arrived into the CVP Servers, then you can run a query against the RCD table on ICM.
While a CVP Reporting Server would inform you on details on the actually call flow users took within CVP application.
Note: the RCD (Router_Call_Detail) table is not a summary table, so run out of hours and / or limit your SQL query to run on a single thread (Google - OPTION (MAXDOP 1)).
Below is a query which groups by DialedNumberString.
You coudl add a filter for Routing Client so you would see only calls for CVP Routing Client(s).
SELECT DialedNumberString, COUNT(DialedNumberString) As NumberOfCalls
FROM Route_Call_Detail
WHERE DateTime > (DateAdd(hh,-1,GetDate()))
GROUP BY DialedNumberString
ORDER By DialedNumberString
Regards,
Gerry
03-09-2015 02:11 PM
There are many ways to do this. What kind of setup do you have ? Do you have reporting server and CUIC. You can get this info from some of the standard CVP reports in CUIC.
Depending on what exactly you need, you could also write some queries and custom scripts to get this info.
Hemal
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide