Software Publisher Summary Chart

Find Which Software Publishers Are Used the Most

With this chart report, you can have a quick overview of the number of times a software publisher's software has been installed. When used on a dashboard you always have the information available at a glance. Below you can see an example of one of the chart options available in the chart report widget.

Software publisher chart

Click to Open - Software Publisher Summary Chart Query
Select Top 1000000 Coalesce(tblSoftwareUni.SoftwarePublisher, N'') As Publisher,
  Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where tblAssetCustom.State = 1
Group By Coalesce(tblSoftwareUni.SoftwarePublisher, N'')
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