Dashboards & Visualizations

How to use value from a drop down that contains reserved characters in a search?


I have a table that shows instances of errors from the event log over time by host.

I use a drop down that searches the event log data for Type="Error" | top limit=20 Message to populate $ErrorMessage$ with the value in the Message column. Then I have a table that uses $ErrorMessage$ and does this search:

Type="Error" Message ="$ErrorMessage$" | eval host=upper(host) | timechart count by host

The table and the drop down both default to 24 hour periods.

It works, except when the Message contains reserved characters, like [ or ]. Then I don't get any matches, even though results show in the drop down.

Do I need to escape characters in $ErrorMessage$ when I do my search for the timechart? If so, how do I do that without knowing what characters will show up or how many?

0 Karma

Ultra Champion

Drop Down search:

| stats count values(host) as host by Message 
| sort 20 - count
| nomv host
| rex field=host mode=sed "s/(\S+)/host=\"\1\" OR /g"
| eval searchquery=trim(host,"OR ")

throw searchquery field.

Timechart search:

Type="Error"  $searchquery$" | eval host=upper(host) | timechart count by host
0 Karma

Ultra Champion
| makeresults
| eval test="[]{}!\"#$%&'()?>< abddeft ?>_test"
| eval test3=replace(test,"[^\w]","_")
| eval test2=$test$

The token looks OK,
If necessary, convert it?

0 Karma


Unfortunately it still came back with no data when I quoted the token and errors when I didn't. I finally got it to work by using the hash for the error message. Thanks.

0 Karma
Get Updates on the Splunk Community!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out &gt;&gt; As our brave ...