List All Installed Windows Software in Your Network
Discover and list all Windows software within your network. Lansweeper automatically scans detailed hardware, software, user and network information from Windows computers. This report lists all Windows software installed alongside the version, publisher and the count of the number of times the software is installed. By filtering and sorting you can easily find the most popular, the least popular or specific software in your environment. The hyperlinked columns allow you to dive deeper into the data and find all machines with a specific software package, specific version or with software from a specific publisher.
All Installed Windows Software Query
Select Top 1000000 tblSoftwareUni.softwareName As Software, tblSoftware.softwareVersion As Version, tblSoftwareUni.SoftwarePublisher As Publisher, Count(tblSoftware.AssetID) As Total From tblSoftware Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Where tblAssetCustom.State = 1 Group By tblSoftwareUni.softwareName, tblSoftware.softwareVersion, tblSoftwareUni.SoftwarePublisher Order By Total Desc