Splunk Search

Using the dedup command

Benny611
Engager

How do I count the number of unique recipients of each type of unique attachment from emails. The same user could receive the same attachment in multiple emails. Using the “dedup” command?

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Use the distinct_count function of the stats command.

| stats dc(recip) as recip_count by attachment_type
---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Use the distinct_count function of the stats command.

| stats dc(recip) as recip_count by attachment_type
---
If this reply helps you, Karma would be appreciated.
0 Karma

Benny611
Engager

@richgalloway Thanks, it worked, and I appreciate it.

Get Updates on the Splunk Community!

AI for AppInspect

We’re excited to announce two new updates to AppInspect designed to save you time and make the app approval ...

App Platform's 2025 Year in Review: A Year of Innovation, Growth, and Community

As we step into 2026, it’s the perfect moment to reflect on what an extraordinary year 2025 was for the Splunk ...

Operationalizing Entity Risk Score with Enterprise Security 8.3+

Overview Enterprise Security 8.3 introduces a powerful new feature called “Entity Risk Scoring” (ERS) for ...