Splunk Search

How to add a first column to number each row in a table so when I export to csv, the results are a list of numbered items?

jimmy_ford
New Member

I have a search with a table as an output, but I want to add the first column to number each row so when I export to csv, the consumers can see the number of items easily. The current search I am using:

index=* action!=blocked dest_ip=< ip's > action!=blocked | dedup src_ip | table _time, src_ip, dest_ip, action, url
Tags (4)
0 Karma

ramdaspr
Contributor
index=* action!=blocked dest_ip=< ip's > action!=blocked | dedup src_ip | table _time, src_ip, dest_ip, action, url | streamstats count as row | fields row *

jimmy_ford
New Member

Thank you but for some reason I see two now.....

blank Row _time
1 1

0 Karma

ramdaspr
Contributor

Can you change the endin to fields row,_time, src_ip, dest_ip, action, url

0 Karma
Get Updates on the Splunk Community!

Splunk Enterprise Security(ES) 7.3 is approaching the end of support. Get ready for ...

Hi friends!    At Splunk, your product success is our top priority. With Enterprise Security (ES), we're here ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk, and empower your SOC to reach new heights! Duration: 1 hour  Prepare to ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...