Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Best way to retrieve CDR info from Database

A. I already know about the CDR analysis tool

but .. I wanted to know if anyone does any direct retrieval of the database items. What do you use to extract the data? Is there an easy way to directly extract the data?

2 REPLIES
New Member

Re: Best way to retrieve CDR info from Database

you can make an odbc connection to the cdr database and pull the information off then you can run your analysis. I do not remember the username and password that it is using but I could find the docs for you.

hope this helps

scott

New Member

Re: Best way to retrieve CDR info from Database

Hi,

I use the ODBC method to collect and manipulate some CDR records. To be on the safe side, create an SQL user that has Read Only access to the CDR Database. Then using something like Excel, you can pull whatever records you need, search etc. Remember the date format on CDR records is time elapsed from 1 Jan 1970., so you will need a conversion formula. I can supply the ODBC DSN Data and Excel formulas if required.

HTH,

Bill.

113
Views
0
Helpful
2
Replies