Reporting

How to export logs to Excel or text file

mbadar
Engager

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

Tags (2)
1 Solution

MHibbin
Influencer

@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

View solution in original post

MHibbin
Influencer

@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

Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...