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.
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.
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?