‎08-08-2019 09:05 PM
‎08-08-2019 09:55 PM
Select Top 1000000
DatePart(yyyy, tblBIOS.ReleaseDate) As Biosyear,
Count(tblAssets.AssetID) As Total
From
tblAssets
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where
tblAssetCustom.State = 1
Group By
DatePart(yyyy, tblBIOS.ReleaseDate)
Order By
Biosyear
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now