topic Re: How to search and filter by a field that contains spaces? in Splunk Search

How to search and filter by a field that contains spaces?

teknet7 — Tue, 24 May 2016 13:06:52 GMT

Hello Team,

I could see a lot of discussions on this forum, but none solving my issue.

I have a log with content like this:

field number1: value1, Application Server=running, Database Server=running

When I try these searches:
Server="running" works fine, but with 'Application Server'="running" or "Application Server"="running" it's not. How can I filter by value of a field which has a space? I need to have logs with Application Server running (not Database Server running).

Thanks,
Michal

Re: How to search and filter by a field that contains spaces?

sjohnson_splunk — Tue, 24 May 2016 14:32:35 GMT

When you view the raw events in verbose search mode you should see the field names. What is the field name? If it is just "server" you should consider creating either an EXTRACT or REPORT in the props.conf for that source or sourcetype.

Re: How to search and filter by a field that contains spaces?

jsven7 — Tue, 08 Aug 2017 13:52:13 GMT

If you're looking for events with Server fields containing "running bunny", this works for me:

Server=*"running bunny"*

Re: How to search and filter by a field that contains spaces?

JL99 — Tue, 12 Mar 2024 16:53:24 GMT

You should able to do that with enclosing your field name with dollar sign ($)

$Application Server$="running"

Refer to: https://community.splunk.com/t5/Splunk-Search/Search-field-names-with-spaces-in-map-command-inner-search/m-p/241379#M71778