Find the Device Age of Devices in Your Network
Having outdated IT equipment is not only an extra burden for IT to support, but can also cost more than simply renewing it with an updated device. To get a sense of the age of your devices, you need a clear overview. 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.
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