How to export logs to Excel or text file

[mbadar]

Hello,

Is it possible to export logs to text or excel file?

Let's say - that I filtered logs originating from device 10.1.1.100 and 10.1.1.200 and want all the logs to be exported to excel or text file - how would I go about do so?

Thank you

[MHibbin · Accepted solution]

@mbadar,

You should add "|outputcsv <filename>" to the end of your search syntax.

For example,

ip=10.1.1.* | outputcsv myresults.csv

Here is the docs for this...

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Outputcsv

I find this quite good in automating the output of this data.

Regards,

MHibbin