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!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

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

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...