Splunk Search

Eval against a lookup

Tika
Explorer

Hello, I am new to Splunk and this is probably a basic query. I have a field with an email address and I want to check if the email exists in a look up table and eval it to 1, if found and 0 if not. 

I also have multiple emails in the field and this is what I have come up with so far, any help is much appreciated.

 

 

 

| rename "my_user.user_email" as email | mvexpand email | stats count by email  | eval useremail= email."@my_domain.com" | table useremail count | lookup userdomain_email email as useremail OUTPUT user as user 

 

 

 

But this gives me counts and Im not sure if the result is accurate either.  Thanks!

Labels (2)
0 Karma
1 Solution

yuanliu
SplunkTrust
SplunkTrust

(Clicked Enter by mistake and for some reason I cannot edit or delete the above.  So here goes)

| eval in_lookup = if(isnull(user), 0, 1)

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi @Tika,

you could run something like this:

your_search
| rename "my_user.user_email" as email 
| mvexpand email 
| stats count by email  
| eval useremail= email."@my_domain.com" 
| append [ | inputlookup userdomain_email | rename email AS useremail | fields useremail ]
| stats sum(count) AS total BY useremail
| eval status=if(total=0,0,1)
| table useremail status

Ciao.

Giuseppe

0 Karma

Tika
Explorer

Thanks! that works

yuanliu
SplunkTrust
SplunkTrust

(Clicked Enter by mistake and for some reason I cannot edit or delete the above.  So here goes)

| eval in_lookup = if(isnull(user), 0, 1)

yuanliu
SplunkTrust
SplunkTrust

There is only one step from your lookup output to 0-or-1 determination: if(X,Y,Z).

Tags (1)
0 Karma
Get Updates on the Splunk Community!

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...