Computer BIOS Age Chart

Find the Device Age of Devices in Your Network

With this chart report, you can have a quick overview of the age of your Windows workstations and servers right on your dashboard so you always have the information available at a glance. Below you can find an example of one of the chart types that can be used in the chart report widget.

BIOS age chart

Computer BIOS Age Chart Query

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

Run This Report in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting