Find that Dinosaur in Your Network

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

"*" indicates required fields

Email*

Hidden

EmailType

Hidden

IM – Conv Page – Processing

Hidden

IM – UTM_Campaign FC – Processing

Hidden

IM – UTM_Campaign LC – Processing

Hidden

IM – UTM_Content FC – Processing

Hidden

IM – UTM_Content LC – Processing

Hidden

IM – UTM_Medium FC – Processing

Hidden

IM – UTM_Medium LC – Processing

Hidden

IM – UTM_Source FC – Processing

Hidden

IM – UTM_Source LC – Processing

Hidden

IM – UTM_Term FC – Processing

Hidden

IM – UTM_Term LC – Processing

Hidden

gclid

Hidden

msclkid

Name

This field is for validation purposes and should be left unchanged.

Count Me In Submit

 

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