Software Publisher Summary Chart

Find Which Software Publishers Are Used the Most

Software is oftentimes one of the most complex items to manage within an IT environment. The variety of software and software publishers can easily become very large. 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.

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.

Software publisher chart

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