09-08-2014 10:46 PM - edited 03-17-2019 12:05 AM
Hi all,
Hoping someone may able to provide some advice. I need to export all cdr records between 'datea' and dateb'.
To do this, I started out by ssh'ing into the pub and doing a 'run sql car select * from tbl_billing_data where date(datetimestamporigination) between 'datea' and 'dateb'
A lot of data came up on the screen, so then I ran 'file list activelog /cm/cdr_repository/preserve/ and a list of date directories appeared. All the directories listed were from the 'dateb', as if all the dates prior to this date have been deleted. Is it possible that from running the sql command it has actually removed those cdr records or moved the somewhere else? Hoping they are still recoverable, any advice appreciated.
Thanks a lot,
Erina
Solved! Go to Solution.
09-09-2014 12:16 AM
Hi Erina,
The sql queries you mentioned will not delete or push the files to some different folder. Do you have a billing server setup for this cluster? Please check the section "Troubleshoot: CDR Files not being transfered to billing server" of the following link
https://supportforums.cisco.com/document/55821/troubleshooting-cdr#Troubleshoot:_CDR_Files_not_being_transfered_to_billing_server
HTH
Manish
09-09-2014 12:16 AM
Hi Erina,
The sql queries you mentioned will not delete or push the files to some different folder. Do you have a billing server setup for this cluster? Please check the section "Troubleshoot: CDR Files not being transfered to billing server" of the following link
https://supportforums.cisco.com/document/55821/troubleshooting-cdr#Troubleshoot:_CDR_Files_not_being_transfered_to_billing_server
HTH
Manish
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