topic Re: Splunk DB Connect SQL query with variables in Splunk Search

Splunk DB Connect SQL query with variables

efn — Tue, 29 Sep 2020 18:59:29 GMT

Hi, I am trying to make a Data Lab Input for Splunk DB Connect using the followng query:

declare @cntr_value_1 numeric(20,3)
declare @cntr_value_2 numeric(20,3)
declare @delay_time varchar(12)
set @delay_time = right(convert(varchar(30),dateadd(second,1,0),121),12)
select @cntr_value_1 = cntr_value
from [master].[dbo].[sysperfinfo]
where counter_name = 'Page reads/sec'
waitfor delay @delay_time
select @cntr_value_2 = cntr_value
from [master].[dbo].[sysperfinfo]
where counter_name = 'Page reads/sec'
SELECT convert(numeric(20,1),round((@cntr_value_2-@cntr_value_1)/1,3)) AS DB_VALUE

The query executes fine, but when I want to save the Input, the following message appears:
There was an error processing your request. It has been logged (ID 13fb315b3ef49ffd).

I wonder if the problem are the variables.

Re: Splunk DB Connect SQL query with variables

amahoski — Thu, 12 Apr 2018 15:41:36 GMT

DBX3 currently does not support using variables within a DB input statement. You can use parameters for things such as rising columns.

http://docs.splunk.com/Documentation/DBX/3.1.3/DeployDBX/Createandmanagedatabaseinputs

Basically, you would likely need to create a view if it is possible for the query you are attempting.

Re: Splunk DB Connect SQL query with variables

dgelo — Thu, 20 Dec 2018 08:14:46 GMT

Hi,

Why it does not support? How can i use db lookup query with variables? Need install oldest db connect (v1) or maybe have workaround?