Splunk Search

How do I Add a filter to mstats?

rolabrie
Loves-to-Learn

Given a query

 

| mstats sum(ktm.lag_ms_count) as sum_count where index=ktm

 

I want to restrict the results based on another attribute like this

 

| mstats sum(ktm.lag_ms_count) as sum_count where index=ktm,ktm.lag_ms_mean > 120000

 

But this doesn't work. Possible to do this kind of filter in mstats? I've been able to do absolute filters

 

where index=ktm,cluster=app

 

But the ranged thing doesn't work

Labels (1)
Tags (2)
0 Karma

rolabrie
Loves-to-Learn

Bump. Anyone out there? This shouldn't be hard: influx and prometheus do it easily. 

0 Karma
Get Updates on the Splunk Community!

The OpenTelemetry Certified Associate (OTCA) Exam

What’s this OTCA exam? The Linux Foundation offers the OpenTelemetry Certified Associate (OTCA) credential to ...

From Manual to Agentic: Level Up Your SOC at Cisco Live

Welcome to the Era of the Agentic SOC   Are you tired of being a manual alert responder? The security ...

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...