Splunk Search

How to get the count of the number of duplicates that have been eliminated using dedup

marty1234
Engager

There are many failures in my logs and many of them are failing for the same reason. I am using this query to see the unique reasons:

index=myIndexVal log_level="'ERROR'" | dedup reason, desc | table reason, desc

I also want a count next to each row saying how many duplicates there were for that reason. Basically I want a frequency count of each type of failure. I am a complete beginner and am in no way married to the above command, in fact the count doesn't even have to be in the table generated by the above query, I just need the numbers and the failure types, it doesn't have to be pretty or anything.

All the other posts I'm seeing seem to require me to know all the failure reasons, as in there needs to be some limited number that I can put into the query, but thats not feasible in my situation.
Thank you in advance.

0 Karma
1 Solution

adonio
Ultra Champion

try this:

index=myIndexVal log_level="'ERROR'" | stats count by reason, desc

View solution in original post

adonio
Ultra Champion

try this:

index=myIndexVal log_level="'ERROR'" | stats count by reason, desc

Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...