Getting Data In

How to create a scheduled search to export results as a CSV file to an external share?

andrei_radu
New Member

Hello,

I need to create a scheduled search on a search head and automatically export the results as a .csv file, then copy the file to an external share that is mapped to my Splunk server (Linux).

I was trying to use CLI splunk search. Ran the command:

splunk search "search string" > -format csv > /myshare/file_name.csv

This works super fine, can be added to crontab, but the problem is that it requires authentication. If I manually authenticate for the first time then add the search into crontab, it will ask for credentials again?

Otherwise, can you suggest any other methods of automatically exporting search results into a file, then copy a file to an external share?

Thanks a lot!

0 Karma

anantdeshpande
Path Finder

Do you have solution now?

0 Karma

somesoni2
SplunkTrust
SplunkTrust

Try like this

1) Add command ...| outputcsv to your search. This will export the search results to location $SPLUNK_HOME/var/run/splunk/csv
https://docs.splunk.com/Documentation/Splunk/6.4.2/SearchReference/Outputcsv

2)Save your search as scheduled saved search and run it at your convenient cron schedule

3) Configure this saved search to run a script as the alert action (alert condition always).

4) Create script (which will run as part of alert action) to copy the exported file from $SPLUNK_HOME/var/run/splunk/csv to your external share.

deva1995
Explorer

Can anyone share the script for copying the file to external server?

0 Karma

mayankm21
New Member

Did you implement this? Can you please share the script? 

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...