type.inbound
and any(body.links,
.href_url.domain.root_domain == "k-mil.net"
and strings.iends_with(.href_url.path, 'official_url')
and strings.icontains(.href_url.query_params, 'u=')
and not regex.icontains(.href_url.query_params,
'u=(?:https?(?:%3a|:))?(?:%2f|\/){2}[^&]*k-mil\.net(?:\&|\/|$)'
)
)
and not sender.email.domain.root_domain == "k-mil.net"
// 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.