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