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

CDR in CCM

How can I get the call detail from CCM CDR?

6 REPLIES

Re: CDR in CCM

If you use the Data Export tool within SQL enterprise manager you can export the contents of the CDR to Excel.

Be warned that on a busy system (200 extensions plus) you can easily expect to fill an excel spreadsheet.

You need to log into the database to do this using ciscoCCMCDR as the username and dipsy as the password.

Once you've got the data you then need to covert the UTC time to normal date-time format but that's not hard to do in Excel.

Paul

Community Member

Re: CDR in CCM

What do you want from the CDRs? If you install the CDR Analysis and Reporting tool from CCM, then you can get most of what you may want either in PDF or CSV format for import into Excel etc. You can also schedule appropriate "reports" and have them emailed to you.

Rory

Community Member

Re: CDR in CCM

Hi,

How do you conver the UTC time to normal date-time format?

Thanks,

Beng

Community Member

Re: CDR in CCM

Hi Beng,

Here's what the release notes say about the time format and converting it to normal date-time format.

All time values are represented as unsigned 32 bit integers. This unsigned integer value is displayed from the database as a signed integer.

This field is a time_t value that is obtained from the Windows NT (2000) system routines. The value is a coordinated universal time (UTC) value, and represents the number of seconds since Midnight (00:00:00) Jan. 1, 1970.

Using Microsoft Excel, you can write a formula to make converting this time stamp a little easier. If the value is in cell A1, you can make another cell:

=A1/86400+DATE(1970,1,1)

There are 86400 seconds in a day. Then format the resulting cell as a date/time field in Excel.

See also http://www.cisco.com/en/US/products/sw/voicesw/ps556/prod_troubleshooting_guide_chapter09186a00800c4bb4.html#xtocid7

Mike.

Community Member

Re: CDR in CCM

Mike,

Thanks for the info. The basic formula works okay but I think I may have to work in 25568 (no of days between 1900 & 1970) in somehow to the formula since Excel works off of 1900.

Sure wish their call detail reporting was simpler. Have a great day!

Beng

Community Member

Re: CDR in CCM

Mike,

Didn't have to take into account the 25,568 number into account. Just selected the entire column that had the formula and changed the format to date/time and it took care of it all.

Thanks again,

Beng

280
Views
0
Helpful
6
Replies
CreatePlease to create content