All Apps and Add-ons

Map search with dbxquery is not returning any Result

Nikitha
Explorer

I have written the below query, but I am not getting any result for this query:

|stats values(val) as val by category |map search="| dbxquery connection=SplunkToHive query="select * from dat where year='2020' and month='08' and day='24' and name like '%$category$%'"  |  table category, value"

 

Can someone please help me ?

inventsekar
SplunkTrust
SplunkTrust

Hi @Nikitha ... not sure how i can help you.. but,.. can you troubleshoot this step by step.. searching only first part, then with a simple map command, then increasing one by one conditions on the map command.. 

let us know how it goes, may be others can help with your further updates. thanks. 

thanks and best regards,
Sekar

PS - If this or any post helped you in any way, pls consider upvoting, thanks for reading !
0 Karma

Nikitha
Explorer

When I try to hardcode the category value, I get 50 events:
| dbxquery connection="SplunkToHive" query="select * from dat where year='2020' and month='08' and day='24' and name like '%Cars%'"  |  table category, value

Only when I use map search, I am not able to get any output. I need to use map search as my Category needs to be an input

Tags (2)
0 Karma
Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...