Dashboards & Visualizations

How to create a dashboard with avg cpu usage over 30 days, per host

bond77s
Explorer

 Im currently using the query to find the cpu utilization for a few host but i want to see the average utilization per host 

tag=name "CPU Utilization" | timechart span=15m max(SysStatsUtilizationCpu) by host limit=0

 

Any information would be helpful

Labels (1)
0 Karma

bond77s
Explorer

It worked,  how do i remove the decimal (floating number)

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| eval average=floor(average)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| timechart span=15m max(SysStatsUtilizationCpu) by host limit=0
| untable _time host SysStatsUtilizationCpu
| stats avg(SysStatsUtilizationCpu) as average by host
0 Karma

bond77s
Explorer

Thank you

0 Karma
Get Updates on the Splunk Community!

Take Your Breath Away with Splunk Risk-Based Alerting (RBA)

WATCH NOW!The Splunk Guide to Risk-Based Alerting is here to empower your SOC like never before. Join Haylee ...

SignalFlow: What? Why? How?

What is SignalFlow? Splunk Observability Cloud’s analytics engine, SignalFlow, opens up a world of in-depth ...

Federated Search for Amazon S3 | Key Use Cases to Streamline Compliance Workflows

Modern business operations are supported by data compliance. As regulations evolve, organizations must ...