Splunk Search

How to filter out event from outbound mail log having "Attachment" field contains file extension ".txt,.html,.jpg,.png"?

Abhineet
Loves-to-Learn Everything

Looking for Splunk query to filter out event if "Attachment" field having extension .txt or .html or .jpg or .png

if only above mentioned file extension available in "Attachment" field then only it should filter out. apart from that if any other file extension available with above mentioned then wee need to consider that event.

Below mentioned is attachment field values in some of event.

Abhineet_1-1670849572980.png

 

red enclosed event should be filtered out as "Attachment" field have only ".txt",".html" and ".png".

other two event have ".txt",".html",".docx" and ".txt",".ics" these two should not filterout.

Labels (1)
Tags (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Here's one approach.  It uses the mvfind function to see if each attachment type is present.  It then filters out the events with all three types.

...
| eval has_txt=mvfind(Attachment, "\.txt"), has_html=mvfind(Attachment, "\.html"), has_png=mvfind(Attachment, "\.png")
| where NOT (has_txt AND has_html AND has_png)

 

---
If this reply helps you, Karma would be appreciated.
0 Karma

Abhineet
Loves-to-Learn Everything

This helps.. thanks

0 Karma

richgalloway
SplunkTrust
SplunkTrust

If your problem is resolved, then please click the "Accept as Solution" button to help future readers.

---
If this reply helps you, Karma would be appreciated.
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 ...