Splunk Search

How to get Mstats sum by time?

pancham
Explorer

Hi Team,

I'm new to Splunk and will need some help in getting this query total sum by timestamp as we are not explicitly

timestamp from code.

|mstats sum(_value) as total WHERE index='abc' | where total>0

Labels (3)
0 Karma

inventsekar
SplunkTrust
SplunkTrust

Hi @pancham ...

Are you sure about the "_value" ?...it looks like missing some portions. 

Example mstats variables:
spl.intr.resource_usage.PerProcess.data.elapsed
os.mem.rss
aws.ec2.CPUUtilization

 

may we know what happens when you run.. 

|mstats sum(value) as total WHERE index='abc' 

thanks and best regards,
Sekar

PS - If this or any post helped you in any way, pls consider upvoting, thanks for reading !
0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...