topic Re: Not able to find REST endpoint for MySQL App to search the database in Getting Data In

Not able to find REST endpoint for MySQL App to search the database

vickypandya — Mon, 08 Oct 2012 19:59:38 GMT

Hello,

I have been using REST for basic searching and getting results from saved searches from splunk via splunk SDK python. Recently I installed MySQL Connector App on my splunk instance. I am wondering if I could do a dbquery search on MySQL App via REST.

I haven't been able to find REST Endpoint to search on MySQL App. I was wondering if someone has already done it or if someone could point me to right direction.

Any help is much appreciated.

Thanks

Vikas

Re: Not able to find REST endpoint for MySQL App to search the database

jbsplunk — Mon, 08 Oct 2012 20:55:25 GMT

You can use the same REST endpoint that you use for regular Splunk searches - just change the search string to use mysqlquery instead

Regular search:
| search foobar | stats count 

dbquery search:
| mysqlquery spec=mydb query="SELECT * FROM foobar LIMIT 10"

Here's how you can use the REST endpoint to create searches
[http://docs.splunk.com/Documentation/Splunk/5.0/RESTAPI/RESTsearches]