<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Extract epoch and tai64 time from imported event in Getting Data In</title>
    <link>https://community.splunk.com/t5/Getting-Data-In/Extract-epoch-and-tai64-time-from-imported-event/m-p/22126#M3359</link>
    <description>&lt;P&gt;You cannot tell Splunk the &lt;CODE&gt;TIME_FORMAT&lt;/CODE&gt; for &lt;CODE&gt;Tai64&lt;/CODE&gt; but if you tell Splunk &lt;CODE&gt;TIME_PREFIX&lt;/CODE&gt; and &lt;CODE&gt;MAX_TIMESTAMP_LOOKAHEAD&lt;/CODE&gt;, it will get it automatically correct (except for sub-seconds) and it should work for both &lt;CODE&gt;epoch&lt;/CODE&gt; and &lt;CODE&gt;Tai64&lt;/CODE&gt;:&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;[sourcetype]
TIME_PREFIX = ^
MAX_TIMESTAMP_LOOKAHEAD = 26
&lt;/CODE&gt;&lt;/PRE&gt;</description>
    <pubDate>Thu, 04 Jun 2015 20:01:41 GMT</pubDate>
    <dc:creator>woodcock</dc:creator>
    <dc:date>2015-06-04T20:01:41Z</dc:date>
    <item>
      <title>Extract epoch and tai64 time from imported event</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/Extract-epoch-and-tai64-time-from-imported-event/m-p/22125#M3358</link>
      <description>&lt;P&gt;Hi&lt;/P&gt;

&lt;P&gt;Do you have any idea to decode Epoch time and Tai64 encoded time? &lt;/P&gt;

&lt;P&gt;I have several device their time is as below..&lt;/P&gt;

&lt;P&gt;completely have no idea on Tai64. for Epoch, I tried to put following in props.conf&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;[sourcetype]
TIME_FORMAT = %s  
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;but do not work .&lt;/P&gt;

&lt;P&gt;Time is Tai64&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;@400000004de5bcd921686bec tcpserver: status: 0/40
@400000004de5bcd921686034 tcpserver: end 10611 status 256
@400000004de5bcd91d08caec tcpserver: ok 10611 0:192.168.2.33:110 :192.168.1.102::2029
@400000004de5bcd91d08c704 tcpserver: pid 10611 from 192.168.1.102
&lt;/CODE&gt;&lt;/PRE&gt;

&lt;P&gt;Time is Epoch&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;1303380720.401    399 192.168.3.32 TCP_MISS/000 3437 GET mail:a@b.c - DIRECT/192.168.2.33 multipart/alternative DETECT-STAT:SPAM:FSIGK/SPAM_CT/4/0/str%3d0001.0A3D0009.4DB002F2.0054%2css%3d4%2cfgs%3d0:::: ACTION:CHANGE_SUBJECT: PROXY-STAT:smtp:0:3392:192.168.3.32:1:0:18:: PROTOCOL-STAT:a@b.c:&amp;lt;SNT115-W4378F7332227898850E657AE920@phx.gbl&amp;gt;: PROXY-ERROR::

1303365337.779    410 192.168.3.32 TCP_MISS/000 3313 GET mail:a@b.c - DIRECT/192.168.2.33 multipart/alternative DETECT-STAT:SPAM:FSIGK/SPAM_CT/3/0/str%3d0001.0A3D0009.4DAFC6DB.0037%2css%3d3%2cfgs%3d0:::: ACTION:CHANGE_SUBJECT: PROXY-STAT:smtp:1:3393:192.168.3.32:1:0:13:: PROTOCOL-STAT:a@b.c:&amp;lt;418ea2af3d2ec5aebde87ee2c78309ad@edm04.01webdesign.com.hk&amp;gt;: PROXY-ERROR::

1303365336.935    404 192.168.3.32 TCP_MISS/000 3308 GET mail:a@b.c - DIRECT/192.168.2.33 multipart/alternative DETECT-STAT:SPAM:FSIGK/SPAM_CT/3/0/str%3d0001.0A3D0009.4DAFC6DA.0054%2css%3d3%2cfgs%3d0:::: ACTION:CHANGE_SUBJECT: PROXY-STAT:smtp:0:3392:192.168.3.32:1:0:16:: PROTOCOL-STAT:a@b.c:&amp;lt;fa4fe4d1cb0c21701daea014a61fdde7@edm04.01webdesign.com.hk&amp;gt;: PROXY-ERROR::
&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Fri, 03 Jun 2011 12:03:20 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/Extract-epoch-and-tai64-time-from-imported-event/m-p/22125#M3358</guid>
      <dc:creator>keiichilam</dc:creator>
      <dc:date>2011-06-03T12:03:20Z</dc:date>
    </item>
    <item>
      <title>Re: Extract epoch and tai64 time from imported event</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/Extract-epoch-and-tai64-time-from-imported-event/m-p/22126#M3359</link>
      <description>&lt;P&gt;You cannot tell Splunk the &lt;CODE&gt;TIME_FORMAT&lt;/CODE&gt; for &lt;CODE&gt;Tai64&lt;/CODE&gt; but if you tell Splunk &lt;CODE&gt;TIME_PREFIX&lt;/CODE&gt; and &lt;CODE&gt;MAX_TIMESTAMP_LOOKAHEAD&lt;/CODE&gt;, it will get it automatically correct (except for sub-seconds) and it should work for both &lt;CODE&gt;epoch&lt;/CODE&gt; and &lt;CODE&gt;Tai64&lt;/CODE&gt;:&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;[sourcetype]
TIME_PREFIX = ^
MAX_TIMESTAMP_LOOKAHEAD = 26
&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Thu, 04 Jun 2015 20:01:41 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/Extract-epoch-and-tai64-time-from-imported-event/m-p/22126#M3359</guid>
      <dc:creator>woodcock</dc:creator>
      <dc:date>2015-06-04T20:01:41Z</dc:date>
    </item>
  </channel>
</rss>

