Splunk Search

How to properly use AND / OR in search?

eddychuah
Path Finder

I'm new to this community, any help will be greatly appreciated!!!

How can i search groups of keywords but i would like the search result to include all of them

Example, give me ALL results where you see SYSERR0001 apple or SYSERR0001 orange or SYSERR0001 grape

i find that if i use the or statement above, splunk search ONLY returns me the right most OR that it finds, however I wish to locate all events that contains the keyword pairs of SYSERR0001 apple or SYSERR0001 orange or SYSERR0001 grape

Tags (3)
0 Karma
1 Solution

eddychuah
Path Finder

nevermind, figured it out

(apple OR orange OR grape) AND SYSERR0001

View solution in original post

0 Karma

eddychuah
Path Finder

nevermind, figured it out

(apple OR orange OR grape) AND SYSERR0001

0 Karma

sideview
SplunkTrust
SplunkTrust

Yep. and by the way "AND" is kinda funny in Splunk. It's always redundant in search, so although Splunk doesn't give you an error, you can always remove it when you see it in the initial search clause, or in a subsequent search command downstream. Another way of looking at this is that Splunk mentally puts an "AND" in between any two terms where there isn't an OR. Thus the explicit ones are unnecessary.

Bottom line - (apple OR orange OR grape) SYSERR0001 will work just as well.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...