Windows: High number of processes running (Built-in)

[Daniel_B]

Old name: Process: High number of processes running (Built-in)

The report below lists Windows computers that have a high number of processes running

The report will only list assets that meet all of the following criteria:

• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once.
  
• The asset is a Windows computer.
  
• The asset has to have more than 70 processes running simultaneously, found during the last scan.
  

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP As SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Count(tblProcesses.ProcessID) As TotalCountProcesses
From tblAssets
  Inner Join tblProcesses On tblAssets.AssetID = tblProcesses.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblState.Statename = 'Active'
Group By tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10),
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried
Having Count(tblProcesses.ProcessID) > 70
Order By TotalCountProcesses Desc,
  tblAssets.Domain,
  tblAssets.AssetName