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!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...