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...)
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."
Confirming that a | dbquery search returned "Search did not return any events." while set to show as "events" but resolved when set to "statistics".
I also had this issue with |dbquery and it resolved as per @unixadmins's suggestions
I am having the same problem. Do you solve it? I tried to change all quotation marks to " but that didn't change anything.