Chart: Computer Bios Age (Built-in)

[Daniel_B]

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)