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 (1)
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!

Detecting Brute Force Account Takeover Fraud with Splunk

This article is the second in a three-part series exploring advanced fraud detection techniques using Splunk. ...

Buttercup Games: Further Dashboarding Techniques (Part 9)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Buttercup Games: Further Dashboarding Techniques (Part 8)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...