CDR Analysis and Reporting

[snootalope]

Hello

Running CCM 3.3(3) here..

Got a couple things here. When doing a CDR Search by User/Extension, and then sending it to my email, it comes as text file. Is there anyway to get that info in an excel spreadsheet? Can they be exported that way from the call manager?

Also, when viewing users/extensions that receive a high amount of calls (100 + a day) it only shows the first 100. Is there a way to increase that so you can see ALL of the calls??

Thanks
Snoots

 

[AdmanOK]

My suggestion to you is to ditch the CDR tool and access the records directly from the database. There should be a database on your publisher server called CDR. The information you are looking for is in the table called "CallDetailRecord" the only thing to look out for is the time fields. To convert them to real times use the formula DATE / 86400 + 25569 and then format the resulting cell to a time/date format and you should be good to go.

 

Ok, found it. It's like 1.2gb, frickin huge.

Anyway, there's a CDR.MDF and a CDR_LOG.LDF, i want the MDF right? Should I be able to open that thing in MS Access or what? How do I get the info out of there?

 

[snootalope]

Oh yeah, do I have to stop the CDR Insert service in order to access that thing? I try opening it, and it says "the file CDR.MDF is currently in use." and it won't let me into it. I tried copying it as well....same thing

 

[redwhip]

Its a SQL data file so you will need to use query analyzer or setup an ODBC data source (odbcad32.exe) to open it from access or Excel.