<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3395" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=487282918-06102008><FONT face=Arial
color=#0000ff size=2>Are we talking about the timestamp in the CDR flat file
itself or the timestamp column inside the file? The timestamp of the CDR
record itself has always been in Unix (epoch) time and that won't change.
I'm not sure how the flat files are named, but I'd expect it to be based on
current server time.</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>-Ryan </FONT></P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of </B>Scott
Voll<BR><B>Sent:</B> Monday, October 06, 2008 2:03 PM<BR><B>To:</B> Wes
Sisk<BR><B>Cc:</B> cisco voip<BR><B>Subject:</B> Re: [cisco-voip] wrong cdr time
stamp in CUCM6.1 !!!<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>
<DIV>How do we change it to local time rather then GMT? It would make
looking at CDRs a whole lot easier.</DIV>
<DIV> </DIV>
<DIV>Scott<BR><BR></DIV>
<DIV class=gmail_quote>On Mon, Oct 6, 2008 at 6:59 AM, Wes Sisk <SPAN
dir=ltr><<A href="mailto:wsisk@cisco.com">wsisk@cisco.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV text="#000000" bgcolor="#ffffff">Djokic,<BR><BR>Is timezone at play here?
In previous CM versions the timestamp columns inside the CSV were in GMT
rather than local time.<BR><BR>/Wes
<DIV>
<DIV></DIV>
<DIV class=Wj3C7c><BR><BR>On 10/6/2008 7:06 AM, Djokic Sinisa wrote:
</DIV></DIV>
<BLOCKQUOTE type="cite">
<DIV>
<DIV></DIV>
<DIV class=Wj3C7c>
<DIV>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">hi group..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">we have cluster of 3 X CUCM
6.1(2) servers..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">for now everything is working
fine..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">few days ago we've activated CDR
file export on remote SFTP location..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">so it's working but the
timestamp which is generated when cdr file is exported - for example
cdr_StandAloneCluster_02_20081006<B><SPAN
style="FONT-WEIGHT: bold">1032</SPAN></B>_16659, is
wrong..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">is not correct it's 2 hours
late..it was <B><SPAN
style="FONT-WEIGHT: bold">12:32</SPAN></B>..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">so, in CUCM administration we
defined NTP server, and pointed all the phones to
it..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">and it's fine, all the phones
show correct time..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">also, in OS Administration we
also pointed CUCMPUB server to NTP server..it says it's synchronized and
it's showing correct time ( when issuing CLI shell commands or when issuing
show system in the web interfcae )..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">so the question is where can be
a problem, bug or misconfiguration of some point?..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">thanx..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">regards..</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><STRONG><B><FONT face=Verdana size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">Sinisa
Djokic</SPAN></FONT></B></STRONG><FONT face=Verdana size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </SPAN></FONT></P>
<P><FONT face=Verdana size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">System
Engineer</SPAN></FONT><BR><FONT face=Verdana size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">CCNP,CCDA,CQS-CWLDS,CS-CIPTDS,CS-CIPCCES
Cisco Certified</SPAN></FONT></P>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<TABLE cellPadding=0 border=0>
<TBODY>
<TR>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><IMG height=94
src="cid:487282918@06102008-0D06" width=60
border=0></SPAN></FONT></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P><FONT face=Verdana size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana">MDS Informaticki
inzenjering</SPAN></FONT><BR><FONT face=Verdana size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana">Bul. Arsenija
Carnojevica 170</SPAN></FONT><BR><FONT face=Verdana size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana">11070 Novi Beograd,
Serbia</SPAN></FONT><BR><FONT face=Verdana size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana">Tel: +381 11 2015 200,
2015 273</SPAN></FONT><BR><FONT face=Verdana size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana">Fax: +381 11 3194
954</SPAN></FONT><BR><A href="http://www.mds.rs/" target=_blank><FONT
face=Arial size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">www.mds.rs</SPAN></FONT></A><BR><A
href="mailto:sdjokic@mds.rs" target=_blank><FONT face=Arial
size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">sdjokic@mds.rs</SPAN></FONT></A></P></TD></TR></TBODY></TABLE>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></DIV></DIV><PRE><HR width="90%" SIZE=4>
_______________________________________________
cisco-voip mailing list
<A href="mailto:cisco-voip@puck.nether.net" target=_blank>cisco-voip@puck.nether.net</A>
<A href="https://puck.nether.net/mailman/listinfo/cisco-voip" target=_blank>https://puck.nether.net/mailman/listinfo/cisco-voip</A>
</PRE></BLOCKQUOTE></DIV><BR>_______________________________________________<BR>cisco-voip
mailing list<BR><A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip"
target=_blank>https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>