Splunk Search

Timechart, last value is always 0

dbcase
Motivator

Hi,

I have this query

index=os sourcetype=vmstat OR sourcetype=cpu OR sourcetype=df  host=betamax-admin   Filesystem="/dev/mapper/vg_betamaxadmin-lv_root" | timechart  span=5m max(PercentUsedSpace)

All it does it gets the % of diskspace used for a given host. Yet when I run it, the most recent value is always 0, which is odd. (see attached pic)

I wait a few minutes and try it again and the time changes but still the value is 0

alt text

1 Solution

somesoni2
Revered Legend

It could be due to the last bin is partial and doesn't contain data, but based on your time range and when you executed the query, it got included in the result. The best option would to be use timechart option partial=false to remove any (generally first and last bin only) partial bins. See this for more info.
http://docs.splunk.com/Documentation/Splunk/6.2.3/SearchReference/timechart#Optional_arguments

index=os sourcetype=vmstat OR sourcetype=cpu OR sourcetype=df  host=betamax-admin   Filesystem="/dev/mapper/vg_betamaxadmin-lv_root" | timechart  partial=f span=5m max(PercentUsedSpace)

View solution in original post

somesoni2
Revered Legend

It could be due to the last bin is partial and doesn't contain data, but based on your time range and when you executed the query, it got included in the result. The best option would to be use timechart option partial=false to remove any (generally first and last bin only) partial bins. See this for more info.
http://docs.splunk.com/Documentation/Splunk/6.2.3/SearchReference/timechart#Optional_arguments

index=os sourcetype=vmstat OR sourcetype=cpu OR sourcetype=df  host=betamax-admin   Filesystem="/dev/mapper/vg_betamaxadmin-lv_root" | timechart  partial=f span=5m max(PercentUsedSpace)

dbcase
Motivator

Thanks Somesoni2! That worked like a charm! Learn something new every day to boot!

0 Karma
Get Updates on the Splunk Community!

Index This | What did the zero say to the eight?

June 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...

Splunk Observability Cloud's AI Assistant in Action Series: Onboarding New Hires & ...

This is the fifth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Now Playing: Splunk Education Summer Learning Premieres

It’s premiere season, and Splunk Education is rolling out new releases you won’t want to miss. Whether you’re ...