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."