Chart: Computer model summary (Built-in)

[Daniel_B]

The report below gives back a list of computer models, with number of computers of each model.

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 LTrim(RTrim(Coalesce(tblAssetCustom.Manufacturer,
  N'Unknown Manufacturer') + N'  ' + Coalesce(tblAssetCustom.Model,
  N'Unknown Model'))) As Compmodel,
  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 LTrim(RTrim(Coalesce(tblAssetCustom.Manufacturer,
  N'Unknown Manufacturer') + N'  ' + Coalesce(tblAssetCustom.Model,
  N'Unknown Model')))
Order By Total Desc,
  Compmodel