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!

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