Splunk Search

Splunk DB Connect SQL query with variables

efn
Engager

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.

amahoski
Explorer

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.

0 Karma

dgelo
Explorer

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?

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...