01-20-2009 07:20 AM - edited 03-15-2019 03:38 PM
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.
01-20-2009 07:53 AM
what is the call manager version?
Also, are the current reports showing different time, could you elaborate it more.
Thanks!
01-20-2009 07:57 AM
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.
01-20-2009 07:13 PM
Could you paste a sample record here?
10-06-2009 06:27 AM
Hello, I'm having this same issue. Were you able to find the cause and solution?
Thanks
10-06-2009 12:32 PM
As I was answered once: "Datetime in table CallDetailRecord (CDR database) always is GMT."
10-06-2009 12:51 PM
really.... good to know! Thanks
10-06-2009 12:54 PM
Was it your problem or not?
10-06-2009 01:00 PM
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).
10-06-2009 01:02 PM
What version of CUCM are you using?
10-06-2009 01:04 PM
6.1.3.1000-16
10-06-2009 01:13 PM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide