<?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: How to create a time series from a log file? in Splunk Search</title>
    <link>https://community.splunk.com/t5/Splunk-Search/How-to-create-a-time-series-from-a-log-file/m-p/601800#M209443</link>
    <description>&lt;P&gt;I think the best solution for me would be to modify the logs to have something like below and use transaction on the new tracker field.&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;06/14/22 12:35:03.022 requestid=1 requestid1 started&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN class=""&gt;06/14/22&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN class=""&gt;12:36:03.022 requestid=1 tracker=Event1 started&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN class=""&gt;06/14/22 1237:03.022 requestid=1 tracker=Event2 started&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN class=""&gt;06/14/22 12:38:03.022 requestid=1 tracker=Event2 ended&lt;BR /&gt;06/14/22 12:39:03.022 requestid=1 tracker=Event1 ended&lt;BR /&gt;06/14/22 12:40:03.022 requestid=1 tracker=requestid1 ended&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Tue, 14 Jun 2022 22:11:38 GMT</pubDate>
    <dc:creator>amdosh</dc:creator>
    <dc:date>2022-06-14T22:11:38Z</dc:date>
    <item>
      <title>How to create a time series from a log file?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/How-to-create-a-time-series-from-a-log-file/m-p/601797#M209442</link>
      <description>&lt;P&gt;I have a log file with a unique identifier (requestid) for a sequence of events. I want to show a breakup of all events within the requestid. I plan to show that by "marking" the start and stop logs of different events (based on the specific log message) I plan to track and finally create some table like this:&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;06/14/22 12:35:03.022 requestid=1requestid1 started&lt;BR /&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;06&lt;/SPAN&gt;/14/22&lt;/SPAN&gt; &lt;SPAN class=""&gt;12:36:03.022 requestid=1 Event1 started&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;06&lt;/SPAN&gt;/14/22 1237:03.022 requestid=1Event2 started&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;06&lt;/SPAN&gt;/14/22 12:38:03.022 requestid=1 Event2 ended&lt;BR /&gt;&lt;SPAN class=""&gt;06&lt;/SPAN&gt;/14/22 12:39:03.022 requestid=1 Event1 ended&lt;BR /&gt;&lt;SPAN class=""&gt;06/14/22 12:40:03.022 requestid=1requestid1 ended&lt;/SPAN&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;Event&amp;nbsp; &amp;nbsp; &amp;nbsp; | Start Time&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; | Duration&lt;BR /&gt;------------------------------------&lt;BR /&gt;Event1|&amp;nbsp;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;06&lt;/SPAN&gt;/14/22&lt;/SPAN&gt; &lt;SPAN class=""&gt;12:36:03.022.&amp;nbsp; &amp;nbsp; &amp;nbsp;|&amp;nbsp; 180&lt;BR /&gt;Event2|&amp;nbsp;&lt;SPAN class=""&gt;06&lt;/SPAN&gt;/14/22 12:37:03.022.&amp;nbsp; &amp;nbsp; &amp;nbsp;|&amp;nbsp; 60&lt;BR /&gt;&lt;BR /&gt;The timeseries will be across the duration of the requestid transaction of 5 mins. Could you let me know how this can be achieved? Thanks!&lt;BR /&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jun 2022 21:46:25 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/How-to-create-a-time-series-from-a-log-file/m-p/601797#M209442</guid>
      <dc:creator>amdosh</dc:creator>
      <dc:date>2022-06-14T21:46:25Z</dc:date>
    </item>
    <item>
      <title>Re: How to create a time series from a log file?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/How-to-create-a-time-series-from-a-log-file/m-p/601800#M209443</link>
      <description>&lt;P&gt;I think the best solution for me would be to modify the logs to have something like below and use transaction on the new tracker field.&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;06/14/22 12:35:03.022 requestid=1 requestid1 started&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN class=""&gt;06/14/22&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN class=""&gt;12:36:03.022 requestid=1 tracker=Event1 started&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN class=""&gt;06/14/22 1237:03.022 requestid=1 tracker=Event2 started&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN class=""&gt;06/14/22 12:38:03.022 requestid=1 tracker=Event2 ended&lt;BR /&gt;06/14/22 12:39:03.022 requestid=1 tracker=Event1 ended&lt;BR /&gt;06/14/22 12:40:03.022 requestid=1 tracker=requestid1 ended&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jun 2022 22:11:38 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/How-to-create-a-time-series-from-a-log-file/m-p/601800#M209443</guid>
      <dc:creator>amdosh</dc:creator>
      <dc:date>2022-06-14T22:11:38Z</dc:date>
    </item>
  </channel>
</rss>

