CDR reports on total calls in

Unanswered Question
May 21st, 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?



I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3.5 (2 ratings)
redrobish Thu, 05/21/2009 - 23:26

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.


tahindley Wed, 05/27/2009 - 10:15

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.


This Discussion