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!

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...