Splunk Search

mstats latest(_time) not working

simpkins1958
Contributor

I am not able to get the latest (or earliest) _time values using mstats.

| mstats sum(bytes) latest(_time)
where index=metrics_app_dest_survey by app_name

is returning:

alt text

0 Karma
1 Solution

simpkins1958
Contributor

Misunderstanding on my part. I thought we could get the earliest/latest time value. Now I see that latest()/earliest() are for the metric value not _time value.

In 7.2 there are new time functions latest_time() and earliest_time() that get the time values.

View solution in original post

simpkins1958
Contributor

Misunderstanding on my part. I thought we could get the earliest/latest time value. Now I see that latest()/earliest() are for the metric value not _time value.

In 7.2 there are new time functions latest_time() and earliest_time() that get the time values.

Vijeta
Influencer

You can get latest(_time), the screenshot you shared shows latest(time) as column name. It should be latest(_time) unless you are renaming _time to time

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...