Find Which Models Are the Most Used in Your Network
With a growing diversity of IT equipment, it is more important than ever to get a clear overview of the state of your IT. With this chart report, you can have a quick overview of the different computer models of your environment 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 Model Summary Chart Query
Select Top 1000000 LTrim(RTrim(Coalesce(tblAssetCustom.Manufacturer, N'') +
N' ' + Coalesce(tblAssetCustom.Model, N''))) As Compmodel,
Count(tblAssets.AssetID) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Group By LTrim(RTrim(Coalesce(tblAssetCustom.Manufacturer, N'') + N' ' +
Coalesce(tblAssetCustom.Model, N'')))
Order By Total Desc,
Compmodel
