Splunk Search

Display row numbers in output

efelder0
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)

sanderdenheijer
Explorer

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

efelder0
Communicator

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

0 Karma

MuS
Legend

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

wrangler2x
Motivator

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

0 Karma
Get Updates on the Splunk Community!

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...

Index This | What goes away as soon as you talk about it?

May 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...

What's New in Splunk Observability Cloud and Splunk AppDynamics - May 2025

This month, we’re delivering several new innovations in Splunk Observability Cloud and Splunk AppDynamics ...