Get an Overview of the CPU and Ram Usage of Your Scanservers

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

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