EmailEvents
| where Timestamp > ago(1d)
| where DeliveryAction == "Delivered"
| join kind=inner EmailAttachmentInfo on NetworkMessageId
| where FileType in~ ("exe", "dll", "scr", "hta", "vbs", "js", "wsf", "iso", "img", "vhd", "lnk", "docm", "xlsm", "pptm")
| project Timestamp, SenderFromAddress, RecipientEmailAddress, Subject, FileName, FileType, SHA256, DeliveryAction
| sort by Timestamp desc