topic Re: Is there a search or command that will number rows in a table? in Splunk Search https://community.splunk.com/t5/Splunk-Search/Is-there-a-search-or-command-that-will-number-rows-in-a-table/m-p/350793#M103848 <P>streamstats might be worth considering. Below is a standalone example.</P> <PRE><CODE>| makeresults count=3 | streamstats count </CODE></PRE> <P>In your case just pipe the query to streamstats</P> <PRE><CODE>.. | streamstats count </CODE></PRE> Wed, 26 Apr 2017 16:44:12 GMT msivill_splunk 2017-04-26T16:44:12Z Is there a search or command that will number rows in a table? https://community.splunk.com/t5/Splunk-Search/Is-there-a-search-or-command-that-will-number-rows-in-a-table/m-p/350790#M103845 <P>is there any command to get row numbers in table?</P> <P>Like,<BR /> I have a table like</P> <PRE><CODE>host source type DFR splunk_id FGH splunkd THG splunk_ui </CODE></PRE> <P>i would like to have like:</P> <PRE><CODE>NO host source type 1 DFR splunk_id 2 FGH splunkd 3 THG splunk_ui </CODE></PRE> Wed, 26 Apr 2017 16:01:00 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-a-search-or-command-that-will-number-rows-in-a-table/m-p/350790#M103845 ThiruSplunk5676 2017-04-26T16:01:00Z Re: Is there a search or command that will number rows in a table? https://community.splunk.com/t5/Splunk-Search/Is-there-a-search-or-command-that-will-number-rows-in-a-table/m-p/350791#M103846 <P>You can try these.</P> <PRE><CODE>your current search | eval NO=1 | accum NO </CODE></PRE> <P>or</P> <PRE><CODE>your current search | streamstats count as NO </CODE></PRE> Wed, 26 Apr 2017 16:37:06 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-a-search-or-command-that-will-number-rows-in-a-table/m-p/350791#M103846 somesoni2 2017-04-26T16:37:06Z Re: Is there a search or command that will number rows in a table? https://community.splunk.com/t5/Splunk-Search/Is-there-a-search-or-command-that-will-number-rows-in-a-table/m-p/350792#M103847 <P>Thank you so much, it works</P> Wed, 26 Apr 2017 16:42:39 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-a-search-or-command-that-will-number-rows-in-a-table/m-p/350792#M103847 ThiruSplunk5676 2017-04-26T16:42:39Z Re: Is there a search or command that will number rows in a table? https://community.splunk.com/t5/Splunk-Search/Is-there-a-search-or-command-that-will-number-rows-in-a-table/m-p/350793#M103848 <P>streamstats might be worth considering. Below is a standalone example.</P> <PRE><CODE>| makeresults count=3 | streamstats count </CODE></PRE> <P>In your case just pipe the query to streamstats</P> <PRE><CODE>.. | streamstats count </CODE></PRE> Wed, 26 Apr 2017 16:44:12 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-a-search-or-command-that-will-number-rows-in-a-table/m-p/350793#M103848 msivill_splunk 2017-04-26T16:44:12Z