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