Find that Dinosaur in Your Network

Hardware-age-Dinosaur

Based on the BIOS release date of your hardware, you can approximately determine your computer hardware age. BIOS is an acronym for Basic Input/Output System, and it's a firmware that's built into your motherboard. Every motherboard comes with BIOS, and in fact, BIOS is the first software that starts once you press the power button on your PC. If there's no purchase date or warranty information available, you can use this report to base your replacement schedule on.

The oldest BIOS we could detect is almost 12 years old! We still use it for testing purposes. Do you have a hardware dinosaur in your network? You can run this report in Lansweeper to do a hardware age check based on the BIOS date. If you haven't already, download a free trial of Lansweeper to run the report.

Get Your Hands on the Latest Network Reports for Free

 

How to Run this Report

  • Open the report builder in the Lansweeper web console under Reports/Create New Report.
  • Paste the SQL query (report) below at the bottom of the page, replacing the default SQL query.
  • Left-click somewhere in the upper section of the page so the query applies.
  • Give the report a title.
  • Hit the Save & Run button to save the report. Export options are listed on the left.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
Convert(nVARCHAR(10),tblBIOS.ReleaseDate,101) As [BIOS Date],
Cast(Round(DateDiff(day, tblBIOS.ReleaseDate, GetDate()) / 365.00,
2) As Numeric(8,2)) As [Years Old],
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Where tblState.Statename = 'Active'
Order By [Years Old] Desc

Try Lansweeper for Free

Learn why Lansweeper is used by thousands of enterprises worldwide.​