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