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

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!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  &#x1f680; Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...