<?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 use transaction to Group multiple events with field values in a specific order in Splunk Search</title>
    <link>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512021#M143592</link>
    <description>&lt;P&gt;hello&lt;/P&gt;&lt;P&gt;conditions are:&lt;/P&gt;&lt;P&gt;if user=A, and The eventid values of the three events are 45, 46 and 48 in sequence，then group this three event。&lt;/P&gt;</description>
    <pubDate>Sat, 01 Aug 2020 16:23:20 GMT</pubDate>
    <dc:creator>qiuxiaoping</dc:creator>
    <dc:date>2020-08-01T16:23:20Z</dc:date>
    <item>
      <title>how to use transaction to Group multiple events with field values in a specific order</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512014#M143590</link>
      <description>&lt;P&gt;hello , i have many logs like:&lt;/P&gt;&lt;P&gt;"_time1 user=A eventid =45"&lt;/P&gt;&lt;P&gt;"_time2 user=A eventid=46"&lt;/P&gt;&lt;P&gt;"_time3 user=A eventid=48"&lt;/P&gt;&lt;P&gt;"_time4 user=B eventid=45"&lt;/P&gt;&lt;P&gt;"_time5 user=A eventid=46"&lt;/P&gt;&lt;P&gt;i want to transaction new event like:&lt;/P&gt;&lt;P&gt;"_time1 user=A eventid=45&lt;/P&gt;&lt;P&gt;_time2 user=A eventid=46&lt;/P&gt;&lt;P&gt;_time3 user=A eventid=48"&lt;/P&gt;</description>
      <pubDate>Sat, 01 Aug 2020 10:35:20 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512014#M143590</guid>
      <dc:creator>qiuxiaoping</dc:creator>
      <dc:date>2020-08-01T10:35:20Z</dc:date>
    </item>
    <item>
      <title>Re: how to use transaction to Group multiple events with field values in a specific order</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512015#M143591</link>
      <description>&lt;P&gt;&amp;nbsp;what is the conditions?&lt;/P&gt;</description>
      <pubDate>Sat, 01 Aug 2020 11:19:39 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512015#M143591</guid>
      <dc:creator>to4kawa</dc:creator>
      <dc:date>2020-08-01T11:19:39Z</dc:date>
    </item>
    <item>
      <title>Re: how to use transaction to Group multiple events with field values in a specific order</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512021#M143592</link>
      <description>&lt;P&gt;hello&lt;/P&gt;&lt;P&gt;conditions are:&lt;/P&gt;&lt;P&gt;if user=A, and The eventid values of the three events are 45, 46 and 48 in sequence，then group this three event。&lt;/P&gt;</description>
      <pubDate>Sat, 01 Aug 2020 16:23:20 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512021#M143592</guid>
      <dc:creator>qiuxiaoping</dc:creator>
      <dc:date>2020-08-01T16:23:20Z</dc:date>
    </item>
    <item>
      <title>Re: how to use transaction to Group multiple events with field values in a specific order</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512515#M143756</link>
      <description>&lt;P&gt;hello&lt;/P&gt;&lt;P&gt;conditions are:&lt;/P&gt;&lt;P&gt;if user=A, and The eventid values of the three events are 45, 46 and 48 in sequence，then group this three event。&lt;/P&gt;</description>
      <pubDate>Wed, 05 Aug 2020 07:36:12 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512515#M143756</guid>
      <dc:creator>qiuxiaoping</dc:creator>
      <dc:date>2020-08-05T07:36:12Z</dc:date>
    </item>
    <item>
      <title>Re: how to use transaction to Group multiple events with field values in a specific order</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512519#M143757</link>
      <description>&lt;LI-CODE lang="markup"&gt;index=_internal 
| head 5 
| fields _time _raw 
| reverse 
| streamstats count 
| eval _raw="user=".if(count=4,"B","A")." eventid=".mvindex(split("45.46.48.45.46","."),count - 1)
| fields - count
| kv 
| rename COMMENT as "this is sample" 
| transaction user maxevents=3&lt;/LI-CODE&gt;&lt;P&gt;see the command reference.&lt;/P&gt;</description>
      <pubDate>Wed, 05 Aug 2020 08:46:53 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512519#M143757</guid>
      <dc:creator>to4kawa</dc:creator>
      <dc:date>2020-08-05T08:46:53Z</dc:date>
    </item>
    <item>
      <title>Re: how to use transaction to Group multiple events with field values in a specific order</title>
      <link>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512661#M143796</link>
      <description>&lt;P&gt;Thankyou for your help. i try your sample case . but it does not meet my request. In my request, 45, 46, and 48 must appear strictly in this order .&amp;nbsp;I have added some content based on yours.&amp;nbsp; pls help me .&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;index=_internal&lt;BR /&gt;| head 10&lt;BR /&gt;| fields _time _raw&lt;BR /&gt;| reverse&lt;BR /&gt;| streamstats count&lt;BR /&gt;| eval _raw="user=".if(count=8,"B","A")." eventid=".mvindex(split("45.46.48.45.48.48.46.48.45.46","."),count -1 )&lt;BR /&gt;| fields -count&lt;BR /&gt;| kv&lt;BR /&gt;| rename COMMENT as "this is sample"&lt;BR /&gt;| transaction user maxevents=3&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qiuxiaoping_0-1596678566260.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/10072i96F30F966EBA10F2/image-size/medium?v=v2&amp;amp;px=400" role="button" title="qiuxiaoping_0-1596678566260.png" alt="qiuxiaoping_0-1596678566260.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 06 Aug 2020 01:54:00 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/how-to-use-transaction-to-Group-multiple-events-with-field/m-p/512661#M143796</guid>
      <dc:creator>qiuxiaoping</dc:creator>
      <dc:date>2020-08-06T01:54:00Z</dc:date>
    </item>
  </channel>
</rss>

