Extract Error Message String

[mkulicke]

I am trying to extract the messages of a commonly used error log:

Creating review recommendations service case activity with errorMessage:  example message one here

Creating review recommendations service case activity with errorMessage:  example message two over here 

I want to do some graphing of counts of the totals of each individual message, so would like to extract the string and stats count by message. Having trouble extracting the string. How do I do this cleanly? The goal would be to have results for

"example message one here" :  X number of results

"example message two over here": Y number of results

[richgalloway · Accepted solution]

You can use the rex command to extract the message text into a field and then use stats to count them.

... | rex "errorMessage: (?<message>.*)"
| stats count by message

[mkulicke]

Perfect, thank you. I was just having trouble extracting the full sentence with my regex, but this solved it perfectly.