Splunk Search

Email count

Benny611
Engager

How do I count the number of emails from a search but only get recipients that received ten or more emails?

Labels (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

First count the number of recipients then filter out those with fewer than 10.

| eventstats dc(emailID) as msg_count by recip
| where msg_count >= 10
| stats dc(emailID) as email_count
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...