Splunk Search

Is it possible to dedup a subset of events?

MatMeredith
Path Finder

I have a list of different events, including some events where name="exception". These exception events have stack traces associated with them. I want to remove duplicate exceptions based on their stack_trace field, but I want to keep all non-exception events because I'm going to need them later. Can I do this?

Effectively I want to do: dedup stack_trace where name="exception"

Labels (1)
Tags (1)
0 Karma

Karthik252
Observer

Does dedup <field_name> keepempty=true work?

0 Karma

cphair
Builder

One way would be to create a new field that contains either the stack_trace value or a value you're pretty confident would be unique in your data, and then dedup on that.


... | eval foo=if(name=="exception", stack_trace, _time . "::" . host ."::" . name) | dedup foo | ...

You might also be able to mess with transaction or stats values(), but those might compress other fields you want to kep.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

You can create a "pretty unique" field using ... | streamstats count

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...