Knowledge Management

Is there a dedup alternative for removing identical events?

TammyF
New Member

Currently my query uses dedup to remove identical events:

dedup comp_id _time

Is there an alternative to dedup to only see unique events?

 

Labels (2)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

The dc function just gives a count of unique values of the specified field.  It's not the same as dedup.  Try this as a dedup alternative:

stats values(*) as * by comp_id check_id _time

 

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...