CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more


Software Publisher Summary Chart

Chart Software

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




Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.