×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

CDR in CCM

Unanswered Question
paul.harrison Fri, 03/28/2003 - 00:22
User Badges:
  • Bronze, 100 points or more

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

rbewlay Fri, 03/28/2003 - 02:38
User Badges:

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


bengster Thu, 04/03/2003 - 06:27
User Badges:

Hi,


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


Thanks,

Beng

mowour Thu, 04/03/2003 - 07:38
User Badges:

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.

bengster Thu, 04/03/2003 - 09:19
User Badges:

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

bengster Thu, 04/03/2003 - 10:53
User Badges:

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

Actions

This Discussion