09-16-2008 03:37 PM - edited 03-15-2019 01:19 PM
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,
MK
09-17-2008 03:12 AM
Anyhelp please? This is kind of urgent.
09-17-2008 04:48 AM
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.
09-17-2008 05:34 AM
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
David
09-17-2008 08:28 AM
I forgot to mention we are using CM5.1.
09-17-2008 08:31 AM
What is your CDR automatic purge set to?
09-17-2008 06:28 PM
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,
09-17-2008 07:26 PM
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.
Thanks
gem
09-18-2008 03:36 AM
You might be able to take it from backup, if you still have backups from June 15th. That's around the time the records would have been purged. Are you running UCCE?
09-18-2008 04:17 PM
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.
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