Computer Model Summary Chart

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 chart

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

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting