Splunk Search

Error in 'search' command: Unable to parse the search: Right hand side of IN must be a collection of literals?

buttsurfer
Path Finder

 

index=index1 type=1 feature IN ([search index=index1 type=type2 application=weather_app
    | dedup feature
    | fields feature
    | format
    ])

 

 

The above code returns this error and i cant seem to figure out how to fix it. Any help would be appreciated

Error in 'search' command: Unable to parse the search: Right hand side of IN must be a collection of literals. '((feature = "feature1") OR (feature = "feature2") OR (feature = "feature3") OR (feature = "feature4") is not a literal.

Labels (1)
0 Karma
1 Solution

buttsurfer
Path Finder

Fixed it by adding 

 

          | dedup feature
          | fields feature
          | format "" "" "" "" "," ""
          | eval search=replace (search, "feature=", "")

 

View solution in original post

0 Karma

buttsurfer
Path Finder

Fixed it by adding 

 

          | dedup feature
          | fields feature
          | format "" "" "" "" "," ""
          | eval search=replace (search, "feature=", "")

 

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @buttsurfer,

you can also use this easier solution:

index=index1 type=1 [search index=index1 type=type2 application=weather_app | rename feature AS query | fields query ]
| ...

Ciao.

Giuseppe

0 Karma
Get Updates on the Splunk Community!

Simplifying the Analyst Experience with Finding-based Detections

    Splunk invites you to an engaging Tech Talk focused on streamlining security operations with ...

[Puzzles] Solve, Learn, Repeat: Word Search

This challenge was first posted on Slack #puzzles channelThis puzzle is based on a letter grid containing ...

[Puzzles] Solve, Learn, Repeat: Advent of Code - Day 4

Advent of CodeIn order to participate in these challenges, you will need to register with the Advent of Code ...