Splunk Search

How to query multiple conditions when the field name has a space

vjverma
Explorer

I need to run a query on the following lines:

index=i source=s earliest=-7W@W latest=@W | timechart span=1w count AS Overall count(eval(field1>0 )) AS F1Count count(eval("Field 2">0)) AS F2Count

The "Field 2" results in a syntax error saying "The eval expression for dynamic field '"Field 2">0' is invalid"

I can't rename the "Field 2". Is they any other way to query this data.

I could do
index=i source=s earliest=-7W@W latest=@W "Field 2">0| timechart span=1w count AS F2Count

but this requires me to run this query multiple times for each field.

Tags (3)
1 Solution

martin_mueller
SplunkTrust
SplunkTrust

Of course you can rename Field 2:

index=i source=s earliest=-7W@W latest=@W | rename "Field 2" as Field_2 | timechart span=1w count AS Overall count(eval(field1>0 )) AS F1Count count(eval(Field_2>0)) AS F2Count

Alternatively you can use single quotes in eval:

index=i source=s earliest=-7W@W latest=@W | timechart span=1w count AS Overall count(eval(field1>0 )) AS F1Count count(eval('Field 2'>0)) AS F2Count

Double quotes would make that a string that can't be compared with a number, causing that error.

View solution in original post

martin_mueller
SplunkTrust
SplunkTrust

Of course you can rename Field 2:

index=i source=s earliest=-7W@W latest=@W | rename "Field 2" as Field_2 | timechart span=1w count AS Overall count(eval(field1>0 )) AS F1Count count(eval(Field_2>0)) AS F2Count

Alternatively you can use single quotes in eval:

index=i source=s earliest=-7W@W latest=@W | timechart span=1w count AS Overall count(eval(field1>0 )) AS F1Count count(eval('Field 2'>0)) AS F2Count

Double quotes would make that a string that can't be compared with a number, causing that error.

vjverma
Explorer

Thank you. Worked like a charm.

0 Karma
Get Updates on the Splunk Community!

Splunk Life | Happy Pride Month!

Happy Pride Month, Splunk Community! 🌈 In the United States, as well as many countries around the ...

SplunkTrust | Where Are They Now - Michael Uschmann

The Background Five years ago, Splunk published several videos showcasing members of the SplunkTrust to share ...

Admin Your Splunk Cloud, Your Way

Join us to maximize different techniques to best tune Splunk Cloud. In this Tech Enablement, you will get ...