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

TRY NOW

Asset Manufacturer Chart

Chart Hardware

Get an Overview of All Manufacturers in Your Network

With IT environments becoming more and more complex, knowing exactly what is in your network is also a tough challenge. With a varied IT environment, knowing which manufactures are present also helps with ensuring full warranty cover.  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.
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.
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

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.