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

Hi,

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

Thanks,

Beng

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.

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

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