Splunk Search

not equal values in a dataset

moayadalghamdi
Path Finder

Hello splunker, i want to write an SPL to list email senders excluding emails in a predefined lookup table.

 

here's my command:

index=email eventtype="email-events" action=delivered [ | inputlookup group_service_emails_csv.csv| fields Emails | where sender != Emails]

please help me with it, Thanks

 

Labels (3)
0 Karma
1 Solution

moayadalghamdi
Path Finder

i found the answer, just write NOT infrot of the lookup search, like this and modify the  WHERE to RENAME:

 

 

index=email eventtype="email-events" action=delivered  NOT [ | inputlookup group_service_emails_csv.csv| fields Emails | rename Emails as sender ]

View solution in original post

0 Karma

moayadalghamdi
Path Finder

i found the answer, just write NOT infrot of the lookup search, like this and modify the  WHERE to RENAME:

 

 

index=email eventtype="email-events" action=delivered  NOT [ | inputlookup group_service_emails_csv.csv| fields Emails | rename Emails as sender ]

View solution in original post

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!