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.
Click to Open - 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