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