Discover what’s new in Lansweeper – Explore our 2024 Summer Launch! 🚀 Learn more

TRY NOW

Computer Model Summary Chart

Chart Hardware

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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.