Splunk Enterprise

Why can't I use trellis with mstats?

robertlynch2020
Influencer

I have a basic SPL using mstat but I can't use treills with it? Any ideas why I can't select "severity"

 

 

 

| mstats count("mx.process.logs") as count WHERE "index"="murex_metrics"  BY severity

 

 

 

 

robertlynch2020_0-1658329597522.png

robertlynch2020_0-1658329766728.png

 

 

Labels (1)
0 Karma
1 Solution

robertlynch2020
Influencer

in the end i needed to add a stats to the end of my SPL to get this to work

 

| mstats count("mx.process.logs") as count WHERE "index"="murex_metrics" mx.env=dell967srv.scz.murex.com:15016 BY severity
| rename count as ErrorCount
| rename severity as lvl
| stats sum(ErrorCount) as Count by lvl
| sort - ErrorCount

View solution in original post

0 Karma

robertlynch2020
Influencer

in the end i needed to add a stats to the end of my SPL to get this to work

 

| mstats count("mx.process.logs") as count WHERE "index"="murex_metrics" mx.env=dell967srv.scz.murex.com:15016 BY severity
| rename count as ErrorCount
| rename severity as lvl
| stats sum(ErrorCount) as Count by lvl
| sort - ErrorCount

0 Karma
Get Updates on the Splunk Community!

Message Parsing in SOCK

Introduction This blog post is part of an ongoing series on SOCK enablement. In this blog post, I will write ...

Exploring the OpenTelemetry Collector’s Kubernetes annotation-based discovery

We’ve already explored a few topics around observability in a Kubernetes environment -- Common Failures in a ...

Use ‘em or lose ‘em | Splunk training units do expire

Whether it’s hummus, a ham sandwich, or a human, almost everything in this world has an expiration date. And, ...