Time difference in Session Details in CDR / Archiving Server

Locked Time difference in Session Details in CDR / Archiving Server

  • Thursday, March 12, 2009 5:16 AM
     
     
    Hi,
    Our OCS CDR server is showing all times in GMT where as the servers are in different time zone.

    E.g. I am in GMT + 5.30 time zone. If I start an IM session at 5.30 PM, CDr shows the session as it was started at 12 PM.

    Do we have any patchs / solutions / workarounds for this.

    Regards
    Prasanna

All Replies

  • Monday, March 16, 2009 3:58 PM
     
     
    Even my Front-end is also recording UTC time stamps instead of Local time on the server on all databases even when used Logging tool its giving UTC time stamps.
  • Thursday, June 25, 2009 6:54 PM
     
     

    All records is on UTC -0 you need to change to your current time when you make a query.

    Example:

    Select SessionIdTime - 0.125 from ...

    These convert to GMT -3


    Bruno Estrozi - MCSE/MCTS/MCITP - Unified Communications Specialist
  • Friday, August 21, 2009 7:14 PM
     
     
    Hello,

    There is any official document from microsoft, which specify the design configuration on OCS Archiving?

    Thanks
    Mauricio L:
  • Friday, August 21, 2009 7:44 PM
     
     
    http://www.microsoft.com/DOWNLOADS/details.aspx?familyid=E9F86F96-AA09-4DCA-9088-F64B4F01C703&displaylang=en
    Bruno Estrozi - MCSE/MCTS/MCITP - Unified Communications Specialist | http://brunoestrozi.spaces.live.com