Dashboards & Visualizations

Dashboard issues - search runs in search window, not in dashboard as an inline string.

bwakely
Explorer

Greetings all,

I've set up the splunk DB connect app (v.117),
I can query an MSSQL database / explore schema.

I can run a search command, example:
|dbquery "MYDB" limit =1000 "select 1"

I cannot get any results returned when I embed this as an inline search into a dashboard panel.
Can someone explain why a saved search works while an inline search doesn't?

(I also can't get '|metatdata hosts' working as an inline string...)

--Benji

Tags (3)

unixadmins
Engager

Poked at it more as a response to your question, and yes, I've found out what's causing it.

With the simple search "|metadata hosts" as an example:

With the visualization type set to "Events", the panel displays "Search did not return any events."
If you change the visualization type to "Statistics", it will happily display data as you'd expect.

I'm not sure of the reason why the output of |commands counts as "statistics" rather than "events",
but that would seem to be the case.

I'm going to put that down as "Confusing, but working as designed."

--Benji

landen99
Motivator

Confirming that a | dbquery search returned "Search did not return any events." while set to show as "events" but resolved when set to "statistics".

nawneel
Communicator

I also had this issue with |dbquery and it resolved as per @unixadmins's suggestions

0 Karma

edrivera3
Builder

I am having the same problem. Do you solve it? I tried to change all quotation marks to " but that didn't change anything.

0 Karma
Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

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

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...