Splunk Search

If i have 3 column in lookup table like column "A" has 10 entries column "B" has 5 entries and column "C" has 2 entries how can i match in search

rahul_mckc_splu
Loves-to-Learn

if i have 3 fields A,B,C and i need to match all entries for that fields
index=main |search [|inputlookup abc.csv | fields A,B,C] | stats count by A,B,C
would this be the right query

Tags (1)
0 Karma

rahul_mckc_splu
Loves-to-Learn

I think it is not working let me put you my query once-again...
I have 3 column in lookup - A,B,C ----A has 10 results B has 5 and c has 3 results..
Now when i run index=main i get 3 fields A has 100+values B has 50+ and C has 30+
But when i match up with |search [|inputlookup abc.csv | fields A,B,C ] so i am suppose to get 10 fields in "A" 5 fields in "B" and then 3 in "C" but it is not giving with your query as well.

0 Karma

elliotproebstel
Champion

There are a few possibilities here. I'll outline some sample data to describe the various options. Let's say your lookup table abc.csv contains the following:

A, B, C
1, 1, 1
2, 2, 3
36, 7, 9

One possibility is that you want to find events in index=main that match this:

(A=1 AND B=1 AND C=1) OR (A=2 AND B=2 AND C=3) OR (A=36 AND B=7 AND C=9)

If so, the code you suggested should work. And you could make it even more efficient by adjusting it like this:

index=main [|inputlookup abc.csv | fields A,B,C] | stats count by A,B,C

Another possibility is that you want to find events in index=main that match this:

 A=1 OR B=1 OR C=1 OR A=2 OR B=2 OR C=3 OR A=36 OR B=7 OR C=9

If so, this would get you there:

index=main [|inputlookup abc.csv | fields A, B, C |  format "" "" "OR" "" "OR" "" ] |stats count by A,B,C

And if you actually wanted to look for all events in index=main that contain the values from A,B,C but may appear anywhere in the events (not necessarily in structured extracted fields), you'd be matching on this:

(1 OR 2 OR 3 OR 36 OR 7 OR 9)

In that case, you could do this:

index=main [|inputlookup abc.csv | eval search=mvappend(A,B,C) | stats values(search) AS search | format ] | stats count by A,B,C
0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...