<?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 How can I find the timezone difference in Splunk indexing for 2 timestamps in an event? in Getting Data In</title>
    <link>https://community.splunk.com/t5/Getting-Data-In/How-can-I-find-the-timezone-difference-in-Splunk-indexing-for-2/m-p/458465#M79232</link>
    <description>&lt;P&gt;I am facing an issue, where there are two timestamps in the events, and I want Splunk to detect the first time stamp, not the second one. How can I get it done? here is a sample event&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;Mar 20 06:27:29 10.214.14.249 id=EQSONICWALL sn=C0EAE4FC9962 time="2019-03-20 05:27:29" fw=10.214.14.249 pri=6 c=1024 m=537
&lt;/CODE&gt;&lt;/PRE&gt;</description>
    <pubDate>Fri, 29 Mar 2019 06:30:30 GMT</pubDate>
    <dc:creator>swmishra_splunk</dc:creator>
    <dc:date>2019-03-29T06:30:30Z</dc:date>
    <item>
      <title>How can I find the timezone difference in Splunk indexing for 2 timestamps in an event?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/How-can-I-find-the-timezone-difference-in-Splunk-indexing-for-2/m-p/458465#M79232</link>
      <description>&lt;P&gt;I am facing an issue, where there are two timestamps in the events, and I want Splunk to detect the first time stamp, not the second one. How can I get it done? here is a sample event&lt;/P&gt;

&lt;PRE&gt;&lt;CODE&gt;Mar 20 06:27:29 10.214.14.249 id=EQSONICWALL sn=C0EAE4FC9962 time="2019-03-20 05:27:29" fw=10.214.14.249 pri=6 c=1024 m=537
&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Fri, 29 Mar 2019 06:30:30 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/How-can-I-find-the-timezone-difference-in-Splunk-indexing-for-2/m-p/458465#M79232</guid>
      <dc:creator>swmishra_splunk</dc:creator>
      <dc:date>2019-03-29T06:30:30Z</dc:date>
    </item>
    <item>
      <title>Re: How can I find the timezone difference in Splunk indexing for 2 timestamps in an event?</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/How-can-I-find-the-timezone-difference-in-Splunk-indexing-for-2/m-p/458466#M79233</link>
      <description>&lt;P&gt;Hi &lt;/P&gt;

&lt;P&gt;You need to make the changes in the props.conf, under which you need to change the time format and you can see the first timestamp With the sample event you have provided you need to makes these changes if you need the first timestamp to be in the event. &lt;/P&gt;

&lt;P&gt;TIME_PREFIX = ^&lt;BR /&gt;
TIME_FORMAT = %b %d %H:%M:%S&lt;BR /&gt;
MAX_TIMESTAMP_LOOKAHEAD =15&lt;/P&gt;</description>
      <pubDate>Tue, 29 Sep 2020 23:54:27 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/How-can-I-find-the-timezone-difference-in-Splunk-indexing-for-2/m-p/458466#M79233</guid>
      <dc:creator>saramamurthy_sp</dc:creator>
      <dc:date>2020-09-29T23:54:27Z</dc:date>
    </item>
  </channel>
</rss>

