type.inbound
and any(body.links,
.href_url.domain.domain == "mail.spiceworks.com"
and strings.icontains(.href_url.query_params,
'_externalContentRedirect'
)
and not regex.icontains(.href_url.query_params,
'_externalContentRedirect=(?:https?(?:%3a|:))?(?:%2f|\/){2}[^&]*spiceworks\.com(?:\&|\/|$|%2f)'
)
)
and not sender.email.domain.root_domain == "spiceworks.com"
// negate highly trusted sender domains unless they fail DMARC authentication
and not (
sender.email.domain.root_domain in $high_trust_sender_root_domains
and coalesce(headers.auth_summary.dmarc.pass, false)
)
Playground
Test against your own EMLs or sample data.