Chart: Software publisher summary (Built-in)

[Daniel_B]

The report below gives back a list of software titles, with count of software titles per publisher.

The report will only list assets that meet all of the following criteria:

• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once.
  
• The asset is a Windows computer.

Select Top 1000000 Case When Len(tblSoftwareUni.SoftwarePublisher) = 0 Or
    tblSoftwareUni.SoftwarePublisher Is Null Then 'Unknown'
    Else tblSoftwareUni.SoftwarePublisher End As Publisher,
  Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where tblState.Statename = 'Active'
Group By (Case When Len(tblSoftwareUni.SoftwarePublisher) = 0 Or
    tblSoftwareUni.SoftwarePublisher Is Null Then 'Unknown'
    Else tblSoftwareUni.SoftwarePublisher End)
Order By Total Desc