Windows: Model by manufacturer (Built-in)

[Daniel_B]

Old name: Computer: Model by vendor (Built-in)

The report below lists computer manufacturers and models with number of scanned computers from each one

The report will only list vendors and models from assets that meet all of the following criteria:

• The asset state is set to "active".
  
• The asset has been successfully scanned at least once.
  
• The asset is a Windows computer.

Select Top 1000000 Coalesce(tblAssetCustom.Manufacturer, N'Unknown') As Vendor,
  Coalesce(tblAssetCustom.Model, N'Unknown') As AssetModel,
  Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Group By Coalesce(tblAssetCustom.Manufacturer, N'Unknown'),
  Coalesce(tblAssetCustom.Model, N'Unknown')
Order By Total Desc,
  Vendor,
  AssetModel