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!

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...

Cloud Monitoring Console - Unlocking Greater Visibility in SVC Usage Reporting

For Splunk Cloud customers, understanding and optimizing Splunk Virtual Compute (SVC) usage and resource ...

Automatic Discovery Part 3: Practical Use Cases

If you’ve enabled Automatic Discovery in your install of the Splunk Distribution of the OpenTelemetry ...