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.
To use this in a chart widget, prefix the report name with «Chart:» and select it in the chart report widget found on a dashboard.
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
