Splunk Search
Highlighted

Display row numbers in output

Communicator

I am indexing a CSV file into Splunk and wish to display the row number in a seperate column called 'row count'.

Example:

Field 1 Field 2 Row Count Field 3
blah blah 1 blah
blah blah 2 blah
blah blah 3 blah

What is the best method to achieve this?

Thanks.

Tags (2)
Highlighted

Re: Display row numbers in output

Communicator

Would displayRowNumbers work here? If so, how would it be configured in my search query?

0 Karma
Highlighted

Re: Display row numbers in output

SplunkTrust
SplunkTrust

Hi efelder0,

you can set this in viewstates.conf or in your XML with this option:

<option name="displayRowNumbers">true</option>

This will work in the recent Splunk releases.

0 Karma
Highlighted

Re: Display row numbers in output

Motivator

Adding to /opt/splunk/etc/apps/search/local/viewstates.conf does not seem to do anything in the search app.

0 Karma
Highlighted

Re: Display row numbers in output

Add ... | streamstats count as "Row Count" to your search

Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.