The report below gives back a list of the BIOS age, with number of computers having a BIOS from each year.
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 DATEPART(yyyy, tblBIOS.ReleaseDate) AS BiosYearReleased,
COUNT(tblAssets.AssetID) AS Total
FROM tblAssets
INNER JOIN tblBIOS ON tblAssets.AssetID = tblBIOS.AssetID
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblState.Statename = 'Active'
GROUP BY DATEPART(yyyy, tblBIOS.ReleaseDate)
ORDER BY DATEPART(yyyy, tblBIOS.ReleaseDate)
