Chart: Asset Manufacturer (Built-in)

[Daniel_B]

The report below gives back a list of manufacturers with count of assets 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.

Select 
 Top 1000000 Case Coalesce(tblAssetCustom.Manufacturer, '')
  When '' Then 'Unknown' 
  Else tblAssetCustom.Manufacturer
  End As AssetManufacturer,
 Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblState.Statename = 'Active'
Group By (Case Coalesce(tblAssetCustom.Manufacturer, '')
  When '' Then 'Unknown' 
  Else tblAssetCustom.Manufacturer End)
Order By Total Desc