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
