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!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...