Chart: Computer manufacturer summary (Built-in)

[Daniel_B]

The report below gives back a list of computer manufacturers, with count of computers from each manufacturer.

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.

SELECT      
 TOP 1000000 CASE COALESCE (tblassetcustom.Manufacturer, '') WHEN '' THEN 'Unknown' ELSE tblassetcustom.Manufacturer END AS CompManufacturer,
 COUNT(tblAssets.AssetID) AS Total
FROM tblAssets 
 INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
 INNER JOIN tsysAssetTypes ON tblAssets.Assettype = tsysAssetTypes.AssetType
 Inner Join tblState On tblState.State = tblAssetCustom.State
WHERE tblState.Statename = 'Active' AND (tsysAssetTypes.AssetTypename =  'Windows' Or tsysAssetTypes.AssetTypename = 'Windows CE')
GROUP BY (CASE COALESCE (tblassetcustom.Manufacturer, '') WHEN '' THEN 'Unknown' ELSE tblassetcustom.Manufacturer END)
ORDER BY Total DESC