Splunk Search

What should be the sequence of using dedup and sort together in a query?

prachi0693
New Member

When dedup is used before sort in a query, the number of events returned is greater than the vice versa.

Tags (2)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

By default, sort only returns 10,000 rows so it's possible that dedup after sort is reducing the count below 10,000 whereas dedup before sort could result in the full 10,000 rows being displayed. It depends on how many duplicate results you have.

If this doesn't explain the behavior, please edit your question to provide more information.

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

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...