topic Re: How to use an additional conditional with the top command (ex: count &gt; 10) and add a sequential number column to the table? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188399#M54268 <P>Hi @okug</P> <P>Try and see if the answer on this post can help answer your 1st question.<BR /> <A href="http://answers.splunk.com/answers/216542/how-to-add-a-first-column-to-number-each-row-in-a.html">http://answers.splunk.com/answers/216542/how-to-add-a-first-column-to-number-each-row-in-a.html</A></P> Wed, 18 Mar 2015 23:27:28 GMT ppablo 2015-03-18T23:27:28Z How to use an additional conditional with the top command (ex: count > 10) and add a sequential number column to the table? https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188395#M54264 <P>Hi, </P> <P>I have questions about the top command.</P> <P>First one is pretty simple.<BR /> How I can add sequential number column in top result table?</P> <P>2nd one is.<BR /> Is there any way to use an additional conditional to top command? I want to do something like:<BR /> top limit=30 and percent &gt; 1 ....<BR /> top limit=50 and count &gt;= 10 ....</P> <P>Thanks!</P> Wed, 18 Mar 2015 14:13:45 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188395#M54264 okug 2015-03-18T14:13:45Z Re: How to use an additional conditional with the top command (ex: count > 10) and add a sequential number column to the table? https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188396#M54265 <P>| top limit=30 xxx | where count &gt; 10</P> Wed, 18 Mar 2015 14:15:57 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188396#M54265 satishsdange 2015-03-18T14:15:57Z Re: How to use an additional conditional with the top command (ex: count > 10) and add a sequential number column to the table? https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188397#M54266 <P>Great! Thanks!!<BR /> Any idea for 1st question?</P> Wed, 18 Mar 2015 20:04:20 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188397#M54266 okug 2015-03-18T20:04:20Z Re: How to use an additional conditional with the top command (ex: count > 10) and add a sequential number column to the table? https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188398#M54267 <P>Try this..</P> <PRE> | top limit=30 | eval s_no =1 | accum s_no | top limit=30 | where percent &gt; 1 | top limit=30 | where count &gt;= 10 </PRE> Wed, 18 Mar 2015 20:11:04 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188398#M54267 pradeepkumarg 2015-03-18T20:11:04Z Re: How to use an additional conditional with the top command (ex: count > 10) and add a sequential number column to the table? https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188399#M54268 <P>Hi @okug</P> <P>Try and see if the answer on this post can help answer your 1st question.<BR /> <A href="http://answers.splunk.com/answers/216542/how-to-add-a-first-column-to-number-each-row-in-a.html">http://answers.splunk.com/answers/216542/how-to-add-a-first-column-to-number-each-row-in-a.html</A></P> Wed, 18 Mar 2015 23:27:28 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188399#M54268 ppablo 2015-03-18T23:27:28Z Re: How to use an additional conditional with the top command (ex: count > 10) and add a sequential number column to the table? https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188400#M54269 <P>Thanks!</P> <P>top limit=30 foo| where percent &gt;= 1 | streamstats count as row | fields row,foo,count,percent</P> <P>worked.</P> Fri, 10 Apr 2015 17:19:10 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188400#M54269 okug 2015-04-10T17:19:10Z Re: How to use an additional conditional with the top command (ex: count > 10) and add a sequential number column to the table? https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188401#M54270 <P>Hi @okug</P> <P>Great <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> glad it worked!</P> Wed, 15 Apr 2015 00:43:14 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-an-additional-conditional-with-the-top-command-ex/m-p/188401#M54270 ppablo 2015-04-15T00:43:14Z