Unanswered Question
Sep 16th, 2008
User Badges:

Hello Folks,

I need to extract some info from our CDR table from april 1th to april 29th. When I go to the CDR administration page to download the CDR dump file, a message stating "the data is only available from july" What can I do? I absolutily need to get the records for the april. With "show status" command, I can see that the publisher is up for only 24 days. Does it mean every time the publisher goes down we lose the CDR data? Is there anywhere where the CDR data is stored?

Thanks guys,


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3 (1 ratings)

Our callmanager is configured to delete records older than 180 days from the call detail record database. We are on version 4.1(3). If you are configured the same, then you will not have records from April 15th. You can check by going to callmanager>applicaitons>cisco callmanager servicibility> cdr analysis and reporting> system> database> configure automatic purge. Hope this helps.

david-lima Wed, 09/17/2008 - 05:34
User Badges:
  • Bronze, 100 points or more

Hi, if you have an CCM 4.3 or earlier try to check if the data exist in the Database. SQL ->SQL Query Analizer->Select CDR Database and execute the query: select * from calldetailrecord.

I hope this help


mightyking Wed, 09/17/2008 - 18:28
User Badges:

It's set to 60 days. If I call Cisco TAC, do you think they have tools to help me to retreive deleted records? I can't express how important is for our organisation to get access to those records btw april 1th and april 29th. Anybody with any ideas are more than welcome.

Thanks guys,

esa786_2 Wed, 09/17/2008 - 19:26
User Badges:

hi if you have back up, is it possible from the backup we can retrive the records. Pls check with the TAC whether you can take it from back, if you are taking back up.



mightyking Thu, 09/18/2008 - 16:17
User Badges:

I think after version 5.X it's called UCCE. We are running 5.1. Unfortunately we don't backup CDR. We only backup the config. Is there any hope to retreive the deleted datas from CallManager.


This Discussion