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!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...