external call cdr

Unanswered Question
May 9th, 2007
User Badges:


Can anyone help?

Some of our users received calls from "external numbers" and displaying "unknown number" even though the caller id is enable. How can we retrieve it or how to get the CDR from the CCM?

We got a CCM 4.1



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
e.huntley Thu, 05/10/2007 - 06:46
User Badges:

Go into CallManager Servicability. This is all assuming CDR is configured properly on the CCM.

But under there, you should have CARS...CDR reporting.

You will have to enter your query data...like an extension and date for example.

I would read about it a little because the time is in GMT and the canned reporting can be hard to deal with. Unless you want to just query the CDR db manually.

redrobish Thu, 05/10/2007 - 15:57
User Badges:

Thanks e.huntley.

Can you give me the step by step? im new in CCM. Also when I can query the CDR db manually...



neesharm Thu, 05/10/2007 - 21:01
User Badges:
  • Bronze, 100 points or more

This is a useful link regarding CAR


Here you can find serach options as e.huntley mentioned


this should server your purpose

To query the sql manually might be a bit complicated ...but we can cross that bridge if it comes

redrobish Thu, 05/10/2007 - 23:07
User Badges:

Thanks neesharm for the reply.

But still I can't see the "external number". The user said that he received a call displaying "external number". no displayed number on it. And when the user lift the handset, no one answers. it happens all the time to him.

My problem is how to retrieve that number?

hope you can help me on this.



neesharm Thu, 05/10/2007 - 23:10
User Badges:
  • Bronze, 100 points or more

if you run a report for the extension(user who said he recived call )using search by extension feature you should see some info ....

let me know what do u find ?

redrobish Thu, 05/10/2007 - 23:26
User Badges:

I see all the call details of the ext w/ 2 incoming calls. the user said it was a valid call to him.

I tried, by gateway then put nothing on route dn, I got some results but the date I need (may 9) is not there. it says " data is not available on date range. data is available only on April 20,2007 to May 7...". What will I do then?



neesharm Thu, 05/10/2007 - 23:33
User Badges:
  • Bronze, 100 points or more

checklist which you can follow to make sure setting are correct

Check the following.

CDR Schedular service should be started and running (this one is one of the major reasons)


System -> Enterprise parameter

Under the CDR Parameters section Verified these three parameter

CDR Format* = CDRs will be inserted into database.

CDR UNC Path = "\\\CDR>"

Local CDR Path* = C:\Program Files\Cisco\CallDetail

CDR Format* = CDRs will be inserted into database

------------ -----------------------------------------------------

Service -> Service Parameter

Selected the publisher and then subscriber.

Verify these service parameter in Both the publisher and subscriber.

under "system" section

CDR Enabled Flag* = "True"

CDR Log Calls with Zero Duration Flag* ="True"

------------ --------------------------------------------------------------

CDR Insert service should only be started Only on Publisher

On subscriber it should be Stopped

Application->sevicability ->tools ->service activation select the publisher.

Cisco CDR Insert activated in publisher.


More links



CDR Analysis and Reporting


redrobish Thu, 05/10/2007 - 23:51
User Badges:

Your a great help!

I seems that I don't have these settings...

Do I need to set a separate pc for the CDR server? what pc specs? what sql server will i put? any other application?

Are those settings applicable to CCM 4.1?

sorry I just new in CDR things...



neesharm Fri, 05/11/2007 - 00:16
User Badges:
  • Bronze, 100 points or more

No you dont need a seprate PC. I asume that you are able to login to CAR tool and Generate reports only thing is that the data is missing for certain date.

Now first of all we need to find if the data is actually there in CDR database(which is where your CAR tool or ART databse pulls it )

These requires looking into sql tables in CDR databse ...since you are new to this I wud suggest opening a TAC case

redrobish Mon, 05/14/2007 - 16:55
User Badges:


where do I find that?

sorry im new...



redrobish Mon, 05/14/2007 - 17:03
User Badges:

Here's what I need.

the report needs to show what is the max number of calls consecutive calls incoming and outgoing combined at one time.

cause our telco advised us to lessen the ISDN calls from 120 to 60 calls.

I need this report...how can I do that?




This Discussion