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

View solution in original post

Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!