Splunk Search

dbxquery bind variable advanced case

thunder_wu
Path Finder

| dbxquery connection=Realtime shortnames=t

query="select * from table_a a
where a.id = ?
and a.create_dt_tm <= trunc(sysdate, 'MI') - interval '60' minute"
params="1234567"

 

For the above query, how to make the create_dt_tm qualification to be bind variable?

0 Karma
Get Updates on the Splunk Community!

AppDynamics Summer Webinars

This summer, our mighty AppDynamics team is cooking up some delicious content on YouTube Live to satiate your ...

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...