Reporting

Can search results be exported using a command in the search script/bar?

myli12
Path Finder

Search results can be exported by clicking on the export link above the search results. Does splunk provide a command/function that can be used in the search bar that pipes search results to a file and the file name can be specified?

Tags (1)
1 Solution

yannK
Splunk Employee
Splunk Employee

yes, check mysearch | outputcsv myfile.csv
the file will be written in $SPLUNK_HOME/var/run/splunk folder

see
http://docs.splunk.com/Documentation/Splunk/4.3/SearchReference/Outputcsv

View solution in original post

yannK
Splunk Employee
Splunk Employee

yes, check mysearch | outputcsv myfile.csv
the file will be written in $SPLUNK_HOME/var/run/splunk folder

see
http://docs.splunk.com/Documentation/Splunk/4.3/SearchReference/Outputcsv

yannK
Splunk Employee
Splunk Employee

no, this is the default location.

Another option is to use the command line search and pipe the result to a file in any folder you are.
example :

/opt/splunk/bin/splunk search "mysearch" -output /myfolder/myfile.csv

see http://docs.splunk.com/Documentation/Splunk/4.3/SearchReference/CLIsearchsyntax

myli12
Path Finder

Thanks, yannK. Can you specify the directory you want the result file save to?

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

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