All Apps and Add-ons

Splunk DB Connect 3.1.1 -- Error in 'dbxquery' command with Server SQL 2008 R2

UNI_Splunk
New Member

Hello,

I am presently putting in place a proof of concept of Splunk Enterprise. I'm trying to access a Microsoft SQL 2008R2 server with the DB Connect addons, The conection seems to work because I see my database list and select one. When I just want to make a select on a table to extract the data, here is the error that I get:

Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255.

Thank you for your help.

0 Karma
1 Solution

bhicks32
Explorer

Hello,

Can you provide the search query you are currently using?

Thanks.

View solution in original post

0 Karma

bhicks32
Explorer

Hello,

Can you provide the search query you are currently using?

Thanks.

0 Karma

bhicks32
Explorer

Try using this syntax:

|dbxquery connection="$ConnectionName$" shortnames=t query="SELECT * FROM $Database.Schema.Table$"

0 Karma

UNI_Splunk
New Member

Alway the same error

Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255.

0 Karma

UNI_Splunk
New Member

SELECT * FROM "Database"."Shema"."Table"

0 Karma
Get Updates on the Splunk Community!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...