Hi, i'm trying to extract substring from a field1 to create field3 and then match field2 with field3
The search is:
index=antispam sourcetype=forcepointmail:sec | fields msg suser from | where NOT LIKE(suser,"%".from."%")
But
from=Domain noreply <noreply@domain.com>
suser=noreply@domain.com
I need to extract the substring contained between <> in the "from" field and match field "suser" with "created_field" .
I want to find each mail where the "From" field is different from "suser" field, so I can find spoofed mails on our antispam device.
thx
... View more