CDR reports time is off

Unanswered Question
Jan 20th, 2009
User Badges:

Hello,


Can one of you enlighten me as to where i would change the time that affects cdr reporting. Our reports are off by 1 hour, when clocks where set back, for some reason, somewhere the timestamp did not get changed. any help is appreciated.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
virverma Tue, 01/20/2009 - 07:53
User Badges:
  • Silver, 250 points or more

what is the call manager version?

Also, are the current reports showing different time, could you elaborate it more.


Thanks!

safety2008 Tue, 01/20/2009 - 07:57
User Badges:

VIRENDER,


cm 5.0. yes the reports we run, through 3rd party vendor all show off 1 hour. like time did not go back 1 hour in october. call manager time shows normal, called 3rd party vendor and we pulled data being sent from cm and all are off 1 hour.

virverma Tue, 01/20/2009 - 19:13
User Badges:
  • Silver, 250 points or more

Could you paste a sample record here?

snooter Tue, 10/06/2009 - 06:27
User Badges:

Hello, I'm having this same issue. Were you able to find the cause and solution?


Thanks

Volodymyr Morskyy Tue, 10/06/2009 - 12:32
User Badges:
  • Bronze, 100 points or more

As I was answered once: "Datetime in table CallDetailRecord (CDR database) always is GMT."

snooter Tue, 10/06/2009 - 13:00
User Badges:

Actually...no. When I export my CDR's to a text file and import them to Excel and use the time cipher:


(B2-21600)/86400+DATE(1970,1,1)


It's off one hour. Behind one hour to be exact. The 21600 is supposed to set it to Central Standard Time, which I'm in. However, I have to set my cipher to 18000, which is Eastern Time, to get the accurate time stamp. So, my CDR's are actually being stamped as though it's set as Mountain Time, and of course I have my CUCM's set as Central Standard (-6:00).

Volodymyr Morskyy Tue, 10/06/2009 - 13:13
User Badges:
  • Bronze, 100 points or more

I had a sort of this problem on my CCM 4.2(3). I'm in Kiev (+2). On Win2k where CCM is installed time zone was "Athens, Istanbul, Minsk +2" but in CCM in Date/Time Groups it was also set to GMT+2 but "GMT +2 Helsnki, Riga, Tallin". Although both time zones were GMT +2 they gave me a difference of 1 hour

Actions

This Discussion