Open redirect: City of Calgary

type.inbound
and any(body.links,
        .href_url.domain.root_domain == 'calgary.ca'
        and .href_url.path =~ '/_layouts/cocis/DirectDownload.aspx'
        and strings.icontains(.href_url.query_params, "redirect")
)
and sender.email.domain.root_domain != 'calgary.ca'

// 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)
)