Splunk Search

Which command can I use to get data from a database? (not "dbxquery")

agentsofshield
Path Finder

I usually use "dbxquery" but it only works in the search app. I'm trying to export data from a database through Splunk SDK, so I'd like to know if there's an alternative command for the same purpose.

0 Karma
1 Solution

agentsofshield
Path Finder

I solved it, my mistake was that the query originally included a lot of quotations, so I added a config file where I wrote all the queries, then imported it to the script with this:

https://docs.python.org/2/library/xml.etree.elementtree.html

So, it's mostly a Python issue not a Splunk issue.

View solution in original post

agentsofshield
Path Finder

I solved it, my mistake was that the query originally included a lot of quotations, so I added a config file where I wrote all the queries, then imported it to the script with this:

https://docs.python.org/2/library/xml.etree.elementtree.html

So, it's mostly a Python issue not a Splunk issue.

horsefez
Motivator

Hi @agentsofshield,

have you found the DB-Connect app yet?

https://splunkbase.splunk.com/app/2686/

Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...