I have a fun task that I was looking for some ideas on. This is CCM 4.1.3
Basically something got messed up and now I am missing records in my ART database between the 2nd and 20th of this month. We resolved the issue on the 21st and now we are happily pushing data to the ART database and are able to run those pretty billing reports.
My problem: The manager is so desperate for this data in a pretty billing report that he's willing to go through all the CDR records 1-by-1 and paste the information into Excel, run algorithms on the data and spit out a report. I told him that is asinine b/c there are well over 45,000 records. He won't finish doing that until mid 2025.
Of course, I can pull the data out with some SQL queries and with some tweaking be able to possibly reproduce these reports to some extent. I don't really want to do that. I'd be much happier if I could just get the data pushed from CDR to ART and let all the built in procedures take care of formatting, calculations, etc...
I opened a TAC case and they said this was not possible, but I don't think he really understood what I wanted. Instead of arguing with him I was wondering if anyone has ran into this before. It has to be rather simple to move the data from CDR to ART b/c CallManager is configured to do this anyway. Why can't I go back a few weeks and get the data that I'm missing?
Any help would be greatly appreciated.