Splunk Search

Count occurrence of message in table

Nilesh067
Explorer

I have a message feild having below data 

 

message=Successfully created  customer id XXXX

message =Duplicate create  customer id XXXX

message=Error while create customer id XXXX

message=Successfully updated customer id XXXX

message=Error while updating  customer id  XXXX

 

can we display it in the below format.

Message                                                               Count

Successfully created  customer id              1

Duplicate create  customer id                        1

Error while create customer id                       1

Successfully updated customer id                1 

Error while updating  customer id                  1

 

if not found the count must be 0

 

 

Labels (6)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| rex field=message "(?<type>(Successfully created|Duplicate create|Error while create|Successfully updated|Error while updating) customer id)"
| stats count by type
| append [| makeresults | eval type="Successfuly created customer id", count=0 | fields type, count ]
| append [| makeresults | eval type="Duplicate create customer id", count=0 | fields type, count ]
| append [| makeresults | eval type="Error while create customer id", count=0 | fields type, count ]
| append [| makeresults | eval type="Successfully updated customer id", count=0 | fields type, count ]
| append [| makeresults | eval type="Error while updating customer id", count=0 | fields type, count ]
| stats sum(count) as count by type​
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...