CPU Utilization Audit

Find CPU Bottlenecks in Your Network

Performance scanning is critical when it comes to managing a network and it's users.  When users start complaining about things being slow, it is easier than ever to locate the cause.  Furthermore, performance monitoring can be used for migration projects as well. Determine how much resources your servers need to so you can set the correct requirements for a cloud or virtual migration.

The audit below will show the top 5 machines with the highest average CPU usage in the last week. This way you can find machines that might be bottlenecked and could use an upgrade. For additional use cases, you can easily modify the audit to include all machines in your network and/or over a longer period of time.

CPU Utilization Query

Select Top 5 tblAssets.AssetID,
  Cast(Avg(tblPerformanceCountersScanMetric.Value) As int) As
  [Average CPU usage in %],
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  Max(tblPerformanceCountersScan.ScanDateTime) As [Last scan]
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblPerformanceCountersScan On tblAssets.AssetID =
  Inner Join tblPerformanceCountersScanMetric On tblPerformanceCountersScan.Id =
  Left Join tblPerformanceCountersScanMetricIdentifier On
    tblPerformanceCountersScanMetricIdentifier.Id =
  Inner Join tsysPerformanceCounterMetric On tsysPerformanceCounterMetric.Id =
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysPerformanceCounterMetric.[Group] = 'CPU' And tblAssetCustom.State = 1
Group By tblAssets.AssetID,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10)
Having Max(tblPerformanceCountersScan.ScanDateTime) > GetDate() - 7
Order By [Average CPU usage in %] Desc


Audit and Take Action in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting