type.inbound
and any(body.links,
.href_url.domain.root_domain == "pirlsandiego.net"
and strings.icontains(.href_url.path, '/LinkClick.aspx')
and strings.icontains(.href_url.url, 'link=')
)
// 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.