All Apps and Add-ons

How to have fields from SQL table to populate dashboard drop-down?

dxw350
Path Finder

I am trying to use the fields that are pulled from the SQL database that were enriched with Splunk DB Connect. When creating a dashboard drop-down list I am trying to replace the previous input of user names using " |inputlookup Employees.csv|search name " and instead replace with a search directly from the database itself. Any command to replace the inputlookup? I was thinking just the "|search name " would have worked, but it didn't

0 Karma
1 Solution

woodcock
Esteemed Legend

You need the dbxquery command to pull directly from the DB, but depending on how often you will be doing this, I would advise against it. Generally the right thing to do is to use dbxquery | outputlookup in a daily/hourly/whatever scheduled search and then use |iinputlookup or |lookup in your dashboards, reports, and searches.

View solution in original post

woodcock
Esteemed Legend

You need the dbxquery command to pull directly from the DB, but depending on how often you will be doing this, I would advise against it. Generally the right thing to do is to use dbxquery | outputlookup in a daily/hourly/whatever scheduled search and then use |iinputlookup or |lookup in your dashboards, reports, and searches.

Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

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

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...