Splunk Search

Grouping multiple OR values

babakkhorshid
New Member

Hi People,
Is there any efficient way of grouping values?
I have like 20 Or statement that I need to match
something like
("x" OR "Y" OR "Z" OR "A" OR "B" OR "C")

Is there any expression like
any of (x,y,z,a,b,c) ?

0 Karma
1 Solution

renjith_nair
Legend

@babakkhorshid,

Try,

field_name IN(x,y,z,a,b,c)

Reference : Multiple field-value comparisons with the IN operator

---
What goes around comes around. If it helps, hit it with Karma 🙂

View solution in original post

0 Karma

renjith_nair
Legend

@babakkhorshid,

Try,

field_name IN(x,y,z,a,b,c)

Reference : Multiple field-value comparisons with the IN operator

---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma

babakkhorshid
New Member

Thanks Renjith

I think this would solve my issue.

But out of interest:
What if the field_Name is not the same.

Like we have Multiple events (like Phrases or words we need to match) in multiple fields?

example: "200" "201" "202" "203" "204" in fields A, B and C

Much appreciate your help and Thanks

0 Karma

renjith_nair
Legend

@babakkhorshid ,
Thanks. Please accept as answer if it's working for you.

For handling different field name, you may use field alias and use the alias in search as described in https://docs.splunk.com/Documentation/Splunk/7.3.1/Knowledge/Addaliasestofields

---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...

Move CrowdStrike FDR ingestion to Data Inputs with a guided migration

CrowdStrike Falcon Data Replicator data is essential for security investigations, detections, and response. It ...

Make Your Machine Data AI-Ready in Splunk

Every team is getting ready for AI agents.    Watch On-Demand   In this Tech Talk, Splunk platform specialists ...