I tried out this new service recently but I'm in trouble with the query syntax.

Do you know how to

  1. Search for given error message types based on string snippets from @message,
  2. Visualize these results on a single graph?

What I found out is

filter @message like /Exception/ | stats count(strcontains(@message, "Pool empty")>0) as poolErrors, count(strcontains(@message, "Login Time-out")>0) as loginErrors by bin(1m)

This should be able to filter out error messages, and give the count of two different errors under two variables.

This filtering seems to work, I just can't list the data in a result log or visualize it.

Or not sure if there is a better way to do it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.