→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
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
0 REPLIES 0