Asset Manufacturer Chart

Get an Overview of All Manufacturers in Your Network

With this chart report, you can have a quick overview of each devices' manufacturer 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 manufacturer chart

Asset Manufacturer Chart Query

Select Top 1000000 Case Coalesce(tblAssetCustom.Manufacturer, '')
    When '' Then 'Unknown'
    Else Coalesce(tblAssetCustom.Manufacturer, '')
  End As AssetManufacturer,
  Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype <> 66
Group By Case Coalesce(tblAssetCustom.Manufacturer, '')
    When '' Then 'Unknown'
    Else Coalesce(tblAssetCustom.Manufacturer, '')
  End
Order By Total Desc

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