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.
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