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