Splunk Search

timechart / chart

tmarlette
Motivator

I know I've done this before, and I've completely forgotten, and I didn't see anything in the documentation on how to chart a value over time of a field. Im' having a complete brain fart.

I am attempeint to chart the value of a field over time (in this case perfmon values)

this is my search:

sourcetype=Perfmon* object=Processor counter="% Processor Time" | timechart Value by host

Can someone please refresh my memory on how to do this?

Tags (2)
0 Karma
1 Solution

linu1988
Champion

Hello,
you are doing it right

sourcetype=Perfmon* object=Processor counter="% Processor Time" instance=_Total| timechart avg(Value) span=1m by host

Thanks

View solution in original post

linu1988
Champion

Hello,
you are doing it right

sourcetype=Perfmon* object=Processor counter="% Processor Time" instance=_Total| timechart avg(Value) span=1m by host

Thanks

linu1988
Champion

The interval you are collecting data that you can mention as span then it will give you the original value.

|timechart avg(Value) span=1m by host useother=f

OR

|timechart per_minute(Value) by host useother=f

OR

|timechart Values(Value) span=Monitored_Interval by host useother=f

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Note, by default Windows Performance Monitor events suppress zero values, giving you inaccurate averages in many cases.
If that's an issue you can force zeroes to be reported through the input.conf stanzas by setting showZeroValue=1.

0 Karma

tmarlette
Motivator

What if I just wanted to chart the values, and not the averages?

0 Karma

somesoni2
Revered Legend

How about "|timechart first(Value) as Value by host"? You can use min or max as well, as long as you keep the span of timechart same as the frequency of events.

0 Karma
Get Updates on the Splunk Community!

Finding Based Detections General Availability

Overview  We’ve come a long way, folks, but here in Enterprise Security 8.4 I’m happy to announce Finding ...

Get Your Hands Dirty (and Your Shoes Comfy): The Splunk Experience

Hands-On Learning and Technical Seminars  Sometimes, you just need to see the code. For those looking for a ...

What’s New in Splunk Observability Cloud: January Feature Highlights & Deep Dives

Splunk Observability Cloud continues to evolve, empowering engineering and operations teams with advanced ...