CDR reports on total calls in

tahindley · ‎05-21-2009

Hi. I'm running CCM 5.1.2 with CAR enabled. I am trying to get a fairly simple report but am new to this and having trouble getting to the right place.

Basically I need to know the number of external calls are coming into all extensions. Only external calls, not internal-to-internal.

Then I need to know, of those calls, how many are getting forwarded to our voicemail extension (3216)?

I'm figuring I'll need to run two reports: one with all extensions(minus 3216), and another with only 3216.

Is this do-able?

Thanks,

Tim

Jaime Valencia · ‎05-21-2009

CAR does not provide means to choose only external or only internal calls, you get ALL calls when running reports.

You can refer to the docs to understand CAR capabilities

Cisco Unified CallManager CDR Analysis and Reporting Administration Guide, Release 5.1(3)

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/5_1_3/car/car.html

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

redrobish · ‎05-21-2009

The only thing you can do here is to create your own reporting tool that gets the data from the SQL table of the CM publisher server like we did. we created an excel (microsoft visual basic) program to pull what we needed or just a simple sql query would do.

hth

tahindley · ‎05-27-2009

Okay, if I export the CDR data to Excel it gives me calling #, called #, and destination #. After that it's just sorting it out with a script or something. Thanks for the help.