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!

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...