topic Re: Export results to .txt in Splunk Search

Export results to .txt

aymericbrun — Thu, 19 May 2011 15:04:32 GMT

Hi,

I was wondering if it's possible to export search and table results in a txt file ? (with a script, a command, ...)

I've seen that was possible to export in json, xml and csv, but not in a txt file.

Thanks

Re: Export results to .txt

bwooden — Thu, 19 May 2011 17:06:17 GMT

There are a few ways to do it.

From the GUI, you should also see a "Raw Events" as an export option along with json, xml, and csv.

From the search language, there are several ways to do it as well. Here is one example that will export to a text file, $SPLUNK_HOME/var/run/splunk/results.txt

outputtext usexml=false | rename _xml as raw | fields raw | fields - _* | outputcsv results.txt

Re: Export results to .txt

aymericbrun — Fri, 20 May 2011 07:58:26 GMT

Works perfectly, great !

Thank you very much

Re: Export results to .txt

aymericbrun — Fri, 20 May 2011 09:45:20 GMT

I have another question 🙂

Everytime i do that command, a new "results.txt" is created, witch replace (and erase) the last "results.txt". Is it possible to write at the end of this file ?

When i start this search, i'd like the results be added at the end of the file, to have a bigger and bigger file everytime i start the search.

Regards

Re: Export results to .txt

bwooden — Fri, 20 May 2011 12:35:39 GMT

outputcsv doesn't currently support an append. So we use it as an input, add a search to it, and the write the results out again...

Re: Export results to .txt

aymericbrun — Mon, 23 May 2011 09:18:05 GMT

Thank you for your quick answer, but the second command you wrote doesn't work. In fact, it works better than your first command, but the results are not appended to the existing results.txt. Splunk keeps creating a new "results.txt" witch contains the results of the last search, results are not added in the existing file.

Here's what i wrote:

Have you an idea ?

Extra : I have a second problem, the search can't finalize because "subsearch auto-finalized after time limit (30 seconds) reached". I search how to disable this but i can't find anything !

Re: Export results to .txt

bwooden — Mon, 23 May 2011 13:19:56 GMT

The above comment should have a '_' prefix before the xml and the asterik but were used to italicize the text between

Re: Export results to .txt

bwooden — Mon, 23 May 2011 13:27:55 GMT

You can prepend instead of append to eliminate the subsearch. NB: In below text, due to comment formatting, replace the two instances of ~ with a _

Re: Export results to .txt

aymericbrun — Mon, 23 May 2011 13:53:07 GMT

Thank you very much for your help! Now it works really well (thanks to your last answer)

Re: Export results to .txt

simonattardGO — Fri, 03 Feb 2012 09:57:56 GMT

Hi,

I found this post very helpful! 🙂

I have a small question about it. Is there a way how to store the exported file in a different folder? Eg. in /tmp/ ?

Thanks a lot!

Re: Export results to .txt

miwalker — Tue, 26 Jun 2012 16:23:19 GMT

+2 for you, works like a champ. Thanks!

Re: Export results to .txt

vkakani60 — Thu, 08 Sep 2016 20:31:29 GMT

But even if you mention results.txt the output would result.txt.csv. I faced the same situation.
The output of the|outputcsv is always .csv ?

Re: Export results to .txt

vkakani60 — Thu, 08 Sep 2016 20:34:32 GMT

NO...! You can't export the |outputcsv to /tmp/ or some other folder, according to the |outputcsv doc

the file will save $SPLUNK_HOME/var/run/*.csv ,
example directory
C:\Program Files\Splunk\var\run\splunk\csv

Re: Export results to .txt

vkakani60 — Thu, 08 Sep 2016 20:37:30 GMT

| outputcsv append=true create_empty=false results

here the search results will be saved in resutls.csv under $SPLUNK_HOME/var/run/*.csv