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
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]
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]