06-02-2017 09:59 AM - edited 03-17-2019 10:29 AM
I am trying to create a SQL query that pulls data from the CDR to give me the total number of calls and the total number of minutes over a specified time range. I would like for this to be all calls on the system but if we have to specify a gateway to run the query that will work also.
06-03-2017 12:29 PM
Hi Jacob,
I think is easiest to collect CDR files from CUCM and get the information from them instead of running a query.
Thinks about it...
Regards
06-05-2017 06:01 AM
We are exporting the CDR to a billing system and I can run all these reports from the telephony billing server. Audit department wants to have a check to make sure that the CUCM is sending all the CDR and this is the reason for trying to run a report directly on the CUCM database.
06-05-2017 06:26 AM
Hello Jacob, you can try something like this
# select N of call within defined period
run sql car select count(*) from car:tbl_billing_data where datetimestamporigination between '2017-06-04 00:00:00' AND '2017-06-05 23:59:59'
# select total duration (seconds) of calls within defined period, also you can divide it by 60 in query to get minutes
run sql car select sum(duration) from car:tbl_billing_data where datetimestamporigination between '2017-06-04 00:00:00' AND '2017-06-05 23:59:59'
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