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!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...