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
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.