All Apps and Add-ons

How to get the DBLOOKUPName from a lookup file (csv)?

rmuraly
Explorer

I have a lookup table with a list of customers and database names

customer.csv loaded into Splunk

customer|db_name
ABC_111|ABC_PROV1
XYZ_211|XYZ_PROV2

I have to do a dblookup using the db_name fetched from customer.csv

|dbquery $db_name$ "SELECT name, duration FROM  tab1"

$db_name$ needs to be fetched form customer.csv

0 Karma

rmuraly
Explorer

I got it working..

Created a saved search for the db_lookup as shown below.
|dbquery $schema_name$ "SELECT name, duration FROM tab1"

save this search as as db_lookup_test

Create a new Saved Search will pass in the parameter schema_name as shown below :
| savedsearch db_lookup_test [|inputlookup customer.csv |eval schema_name=db_info | return schema_name]

rmuraly
Explorer

|inputlookup customer.csv | eval schema_name=db_name |dbquery $schema_name$ "SELECT name, duration FROM tab1"

This is what I am trying to do. I need to get the schema_name dynamically from another lookup

0 Karma
Get Updates on the Splunk Community!

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...

Edge Processor Scaling, Energy & Manufacturing Use Cases, and More New Articles on ...

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