Splunk Search

How to combine multiple search raw strings in a single query

rkishoreqa
Communicator

Hi, 

 

I need to do search with multiple raw strings within a single query.  When I search these strings separately, I am able to get the results.  But when I combine these it is not giving the results and ending with 'No results found'. 

The below three queries are working fine.

  • sourcetype="States*"  *Karnataka*
  • sourcetype="States*"  *Tamil Nadu*
  • sourcetype="States*"  *Mumbai*

When I execute the below query I am getting 'No results found' comment. 

  • sourcetype="States*"  *Karnataka*  *Tamil Nadu*  *Mumbai*

Can anyone through some light on this, thanks in advance.

Tags (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

SPL inserts an implicit AND between each search term.  To search for optional terms, insert an explicit OR.

sourcetype="States*" ("*Karnataka*" OR "*Tamil Nadu*" OR "*Mumbai*")

 

---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

SPL inserts an implicit AND between each search term.  To search for optional terms, insert an explicit OR.

sourcetype="States*" ("*Karnataka*" OR "*Tamil Nadu*" OR "*Mumbai*")

 

---
If this reply helps you, Karma would be appreciated.

saravanan90
Contributor

Please use "OR" inbetween the searches..

sourcetype="States*"  (*Karnataka*  OR  *Tamil Nadu* OR  *Mumbai*)

Get Updates on the Splunk Community!

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...