CDR reports time is off

Unanswered Question
Jan 20th, 2009

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.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
virverma Tue, 01/20/2009 - 07:53

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

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.

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

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

Thanks

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

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

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