Splunk Search

Can you help me with a problem with an AND operator in a CASE and IF statement?

kumagaur
New Member

I have one lookup in which there is a field which consist

Team Member
A1
A2
A3
A4
A5
A6
A7

Now,If
TeamMember=(A1 OR A2) AND A4 AND A7 then print Aseries
TeamMember=(A1 OR A2) and A5 AND A6 then print Bseries

I tried:

 |eval Team=if((con1=="A1 OR con1=A2)"AND con1=="A4" AND con1=A7,Aseries,Other)

I used case as well but no luck.

0 Karma

MuS
SplunkTrust
SplunkTrust

Hi kumagaur,

based on the provided examples this will work:

| makeresults 
| eval TeamMember="A1 A2 A3 A4 A5 A6 A7"
| makemv TeamMember 
| mvexpand TeamMember 
| eval Team = if((TeamMember="A1" OR TeamMember="A2") AND TeamMember="A4" AND TeamMember="A7", "foo" , "nope")

But, also based on your provided information this eval will never match anything because TeamMember has never at the same time either A1 or B2 and A4 and A7.

I would review either the use case or the events, because this based on the provided information will never work.

Hope this helps ...

cheers, MuS

0 Karma
Get Updates on the Splunk Community!

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...

Ready, Set, SOAR: How Utility Apps Can Up Level Your Playbooks!

 WATCH NOW Powering your capabilities has never been so easy with ready-made Splunk® SOAR Utility Apps. Parse ...