‎11-20-2014 11:09 AM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now