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!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...