Splunk Search

How to remove duplicates rows based on all fields, not just one field, and display the unique rows?

LearningGuy
Motivator

how to remove duplicates rows based on all fields, not just one field, and display the unique rows?
Let say there are 10 fields, when I used | dedup 10 field1, field2, ..  field 10,  the result missed some unique rows

Please help. Thank you

0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

The 10 means keep 10 occurrences of the "unique" fields - try 

| dedup field1 field2 ... field10

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

The 10 means keep 10 occurrences of the "unique" fields - try 

| dedup field1 field2 ... field10

isoutamo
SplunkTrust
SplunkTrust
Hi
You could do “dedup _raw”
r. Ismo
Get Updates on the Splunk Community!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...