Get an Overview of the CPU and Ram Usage of Your Scanservers
Lansweeper automatically retrieves performance data from scanservers. Using this data, we can provide details like the CPU usage and RAM usage of your scanning server so that you can monitor that your scanservers aren’t getting bottlenecked by the amount of scanning you ask of them. Both of the charts below show you data from the last 7 days. You can read more about using this data in the Pro Tips blog post.
To use this in a chart widget, prefix the report name with «Chart:» and select it in the chart report widget found on a dashboard.
Scanserver CPU Usage Chart Query
Select Top 1000000 Concat(Min(a.AssetName), ' - Minimim RAM Usage %') As
AssetName,
Min(pcsm.Value) As Value
From tblAssets a
Inner Join tblAssetCustom ac On a.AssetID = ac.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = a.Assettype
Inner Join tblState On tblState.State = ac.State
Inner Join tblPerformanceCountersScan pcs On pcs.AssetId = a.AssetID
Inner Join tblPerformanceCountersScanMetric pcsm On
pcsm.PerformanceCountersScanId = pcs.Id
Inner Join tsysPerformanceCounterMetric pcm On pcm.Id = pcsm.Metric
Left Join tblPerformanceCountersScanMetricIdentifier pcsmi On
pcsmi.Id = pcsm.PerformanceCountersScanMetricIdentifierId
Where tblState.Statename = 'Active' And pcs.ScanDateTime > GetDate() - 7 And
a.Assettype = -1 And a.AssetName = a.Scanserver And
pcm.Name = 'Used physical memory'
Group By a.AssetID,
pcm.Id,
pcsmi.Id
Union All
Select Top 1000000 Concat(Min(a.AssetName), ' - Maximum RAM Usage %') As
AssetName,
Max(pcsm.Value) As Value
From tblAssets a
Inner Join tblAssetCustom ac On a.AssetID = ac.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = a.Assettype
Inner Join tblState On tblState.State = ac.State
Inner Join tblPerformanceCountersScan pcs On pcs.AssetId = a.AssetID
Inner Join tblPerformanceCountersScanMetric pcsm On
pcsm.PerformanceCountersScanId = pcs.Id
Inner Join tsysPerformanceCounterMetric pcm On pcm.Id = pcsm.Metric
Left Join tblPerformanceCountersScanMetricIdentifier pcsmi On
pcsmi.Id = pcsm.PerformanceCountersScanMetricIdentifierId
Where tblState.Statename = 'Active' And pcs.ScanDateTime > GetDate() - 7 And
a.Assettype = -1 And a.AssetName = a.Scanserver And
pcm.Name = 'Used physical memory'
Group By a.AssetID,
pcm.Id,
pcsmi.Id
Union All
Select Top 1000000 Concat(Min(a.AssetName), ' - Average RAM Usage %') As
AssetName,
Round(Cast(Avg(pcsm.Value) As float), 0) As Value
From tblAssets a
Inner Join tblAssetCustom ac On a.AssetID = ac.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = a.Assettype
Inner Join tblState On tblState.State = ac.State
Inner Join tblPerformanceCountersScan pcs On pcs.AssetId = a.AssetID
Inner Join tblPerformanceCountersScanMetric pcsm On
pcsm.PerformanceCountersScanId = pcs.Id
Inner Join tsysPerformanceCounterMetric pcm On pcm.Id = pcsm.Metric
Left Join tblPerformanceCountersScanMetricIdentifier pcsmi On
pcsmi.Id = pcsm.PerformanceCountersScanMetricIdentifierId
Where tblState.Statename = 'Active' And pcs.ScanDateTime > GetDate() - 7 And
a.Assettype = -1 And a.AssetName = a.Scanserver And
pcm.Name = 'Used physical memory'
Group By a.AssetID,
pcm.Id,
pcsmi.Id
Scanserver RAM Usage Chart Query
Select Top 1000000 Concat(Min(a.AssetName), ' - Minimim CPU Usage %') As
AssetName,
Min(pcsm.Value) As Value
From tblAssets a
Inner Join tblAssetCustom ac On a.AssetID = ac.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = a.Assettype
Inner Join tblState On tblState.State = ac.State
Inner Join tblPerformanceCountersScan pcs On pcs.AssetId = a.AssetID
Inner Join tblPerformanceCountersScanMetric pcsm On
pcsm.PerformanceCountersScanId = pcs.Id
Inner Join tsysPerformanceCounterMetric pcm On pcm.Id = pcsm.Metric
Left Join tblPerformanceCountersScanMetricIdentifier pcsmi On
pcsmi.Id = pcsm.PerformanceCountersScanMetricIdentifierId
Where tblState.Statename = 'Active' And pcs.ScanDateTime > GetDate() - 7 And
a.Assettype = -1 And a.AssetName = a.Scanserver And pcm.Name = 'CPU Usage'
Group By a.AssetID,
pcm.Id,
pcsmi.Id
Union All
Select Top 1000000 Concat(Min(a.AssetName), ' - Maximum CPU Usage %') As
AssetName,
Max(pcsm.Value) As Value
From tblAssets a
Inner Join tblAssetCustom ac On a.AssetID = ac.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = a.Assettype
Inner Join tblState On tblState.State = ac.State
Inner Join tblPerformanceCountersScan pcs On pcs.AssetId = a.AssetID
Inner Join tblPerformanceCountersScanMetric pcsm On
pcsm.PerformanceCountersScanId = pcs.Id
Inner Join tsysPerformanceCounterMetric pcm On pcm.Id = pcsm.Metric
Left Join tblPerformanceCountersScanMetricIdentifier pcsmi On
pcsmi.Id = pcsm.PerformanceCountersScanMetricIdentifierId
Where tblState.Statename = 'Active' And pcs.ScanDateTime > GetDate() - 7 And
a.Assettype = -1 And a.AssetName = a.Scanserver And pcm.Name = 'CPU Usage'
Group By a.AssetID,
pcm.Id,
pcsmi.Id
Union All
Select Top 1000000 Concat(Min(a.AssetName), ' - Average CPU Usage %') As
AssetName,
Round(Cast(Avg(pcsm.Value) As float), 0) As Value
From tblAssets a
Inner Join tblAssetCustom ac On a.AssetID = ac.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = a.Assettype
Inner Join tblState On tblState.State = ac.State
Inner Join tblPerformanceCountersScan pcs On pcs.AssetId = a.AssetID
Inner Join tblPerformanceCountersScanMetric pcsm On
pcsm.PerformanceCountersScanId = pcs.Id
Inner Join tsysPerformanceCounterMetric pcm On pcm.Id = pcsm.Metric
Left Join tblPerformanceCountersScanMetricIdentifier pcsmi On
pcsmi.Id = pcsm.PerformanceCountersScanMetricIdentifierId
Where tblState.Statename = 'Active' And pcs.ScanDateTime > GetDate() - 7 And
a.Assettype = -1 And a.AssetName = a.Scanserver And pcm.Name = 'CPU Usage'
Group By a.AssetID,
pcm.Id,
pcsmi.Id
