New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


Is there a way to do a CPU usage correlation report from PRTG

Votes:

0

Your Vote:

Up

Down

I have a group of servers I'm trying to find an optimal maintenance window for. My thought was to compare CPU usage on all the servers and find a time/day each week where they all consistently have low CPU usage to install patches and reboot the servers. Unfortunately it doesn't look like any of the reports built into PRTG have anywhere near this level of sophistication. Has anybody out there found a way to build a report similar to this or used an external program to grab PRTG data and create something like this?

cpu prtg wmi

Created on Mar 23, 2016 5:45:07 PM by  rslater (0) 1



2 Replies

Votes:

0

Your Vote:

Up

Down

Hi rslater

I think thats not something you can achive with PRTG...BUT... Because I like scripting with powershell:

Create a textfile named "loadtimes.csv" with all you servers and enter something like: Time;Server1;Server2;Server2;Server3;Server4;Server5

Create a textfile with all your servers in it, separated in each line (servers.txt)

Server1
Server2
Server3
Server4
Server5

Create a powershellscript (getLoads.ps1)

$servers = get-content servers.txt
$varTime = get-date -Format t

$servers | foreach-Object {
	$varCPU = Get-Wmiobject -computername $_ win32_processor | select LoadPercentage
	$Output = $Output + ";" + $varCPU.LoadPercentage
	}
add-content loadtimes.txt $varTime$Output

Execute the Powershell script every 5 minutes or so. It will measure the CPU Loadtimes of your servers and enter the values in the file "Loadtimes.csv". First Line will be the time, the others the cpu load.

You may have to alter some things, because I use German timecode 24h

Output:

Time;Server1;Server2;Server2;Server3;Server4;Server5
14:41;26;30;19;44;13;26
14:42;57;7;19;24;15;33
14:43;54;8;22;15;7;35
14:44;4;16;26;16;10;12
14:45;4;18;21;4;43;5
14:46;18;8;12;16;30;15

Have fun
Thomas

Created on Mar 24, 2016 1:51:39 PM by  Thomas Umbricht (2,820) 2 3



Votes:

0

Your Vote:

Up

Down

hmm....The PRTG data extractor might help you here. I think a manual process is fine since its something you might run every 3-6 months.

Just wack it over to excel, do some fancy charting on it and you should be able to see the dip you are looking for.

If you need to automate that, have a look at my PRTG Powershell API interface, it will let you automate the data extracting, and then you can code up the logic of when the best time is, or just get Powershell to chart it for you.

Or maybe you can use the sensor factory to group all the channels to one device, then just graph that. This does not scale very well.

On a side note (not directly related to your question, and can be ignored), outage windows should be defined in the service catalog for each service (at least in ITIL), and have been approved and agreed to by the business and IT. But like a said, it a very generic statement and does not suit many real life setups.

Let us know what you settle for.

Created on Mar 28, 2016 10:20:28 AM by  AndrewG (1,782) 2 2



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.