Reporting

Send search results to a MySQL database periodically

MaximeM
Explorer

Hi there.

I would like to send some data from a periodic search to a MySQL database on a remote server.
What are my options ?

Tags (3)
0 Karma

jharty_splunk
Splunk Employee
Splunk Employee

Try using the MySQL connector
http://splunk-base.splunk.com/apps/36664/splunk-mysql-connector

Alternatively, you could output the results of the search to CSV ("| [search] | outputcsv outputfile.csv") and use Mysql Load data infile.

MaximeM
Explorer

Thanks for your answer.
I already tried to use MySQL Connector but I can't figure how to get an automated way to output my search results to my mySQL database.

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...