Notification

Icon
Error

Performance REPORT:AVERAGE CPU, RAM & DISK USAGE IN %

Posted: Wednesday, January 13, 2021 3:57:47 PM(UTC)
MassimoAfros

MassimoAfros

Member Original PosterPosts: 4
0
Like
good morning.
I found these instructions for two separate reports, covering average CPU and RAM usage:

CPU:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
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 =
tblPerformanceCountersScan.AssetId
Inner Join tblPerformanceCountersScanMetric On tblPerformanceCountersScan.Id =
tblPerformanceCountersScanMetric.PerformanceCountersScanId
Left Join tblPerformanceCountersScanMetricIdentifier On
tblPerformanceCountersScanMetricIdentifier.Id =
tblPerformanceCountersScanMetric.PerformanceCountersScanMetricIdentifierId
Inner Join tsysPerformanceCounterMetric On tsysPerformanceCounterMetric.Id =
tblPerformanceCountersScanMetric.Metric
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysPerformanceCounterMetric.[Group] = 'CPU' And tblAssetCustom.State = 1
Group By tblAssets.AssetID,
tblAssets.AssetName,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10)
Having Max(tblPerformanceCountersScan.ScanDateTime) > GetDate() - 7
Order By [Average CPU usage in %] Desc


RAM:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
Cast(Avg(tblPerformanceCountersScanMetric.Value) As int) As
[Avarage RAM 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 =
tblPerformanceCountersScan.AssetId
Inner Join tblPerformanceCountersScanMetric On tblPerformanceCountersScan.Id =
tblPerformanceCountersScanMetric.PerformanceCountersScanId
Left Join tblPerformanceCountersScanMetricIdentifier On
tblPerformanceCountersScanMetricIdentifier.Id =
tblPerformanceCountersScanMetric.PerformanceCountersScanMetricIdentifierId
Inner Join tsysPerformanceCounterMetric On tsysPerformanceCounterMetric.Id =
tblPerformanceCountersScanMetric.Metric
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysPerformanceCounterMetric.Name = 'Used physical memory' And
tblAssetCustom.State = 1
Group By tblAssets.AssetID,
tblAssets.AssetName,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10),
tsysPerformanceCounterMetric.Name
Having Max(tblPerformanceCountersScan.ScanDateTime) > GetDate() - 7
Order By [Avarage RAM usage in %] Desc


Please, does anyone know a way to merge these two reports in order to have a single report with the average usage of RAM and CPU (possibly even the disk please?)

Active Discussions

Report Center Shares on Windows computers and their share permissions
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 4:51:50 PM(UTC)
Lansweeper Asset management/replacement
by  DeviantTomato  
Go to last post Go to first unread
Last post: 3/1/2021 9:01:02 AM(UTC)
Lansweeper Turn off graphical report builder
by  Tenacious  
Go to last post Go to first unread
Last post: 2/23/2021 7:53:03 PM(UTC)
Report Center Reference software list
by  DeviantTomato  
Go to last post Go to first unread
Last post: 2/23/2021 1:16:48 PM(UTC)
Lansweeper Report Filtering Uptime
by  CyberCitizen   Go to last post Go to first unread
Last post: 2/22/2021 12:28:22 AM(UTC)
Lansweeper Adobe Report for CVE-2021-21017
by  baycrest  
Go to last post Go to first unread
Last post: 2/10/2021 2:27:57 PM(UTC)