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

Click to Open - 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