Asset Type Chart

Get an Overview of the Types of Devices in Your Environment

With this chart report, you can have a quick overview of your asset types 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.

Asset type chart

Click to Open - Asset Type Chart Query
Select Top 1000000 tsysAssetTypes.AssetTypename,
  Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssetCustom.State = 1 And tblAssets.Assettype <> 66
Group By tsysAssetTypes.AssetTypename
Order By Total Desc

Run This Report in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting