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!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...