Windows Server Software Audit
Miscellaneous SoftwareDiscover Windows Server Software
Leverage Lansweeper’s powerful scanning capabilities to uncover precise details about the software installed on your servers. Go beyond simple detection and identify specific software versions. Keeping track of software versions ensures you stay vigilant against vulnerabilities, facilitating proactive updates and security measures. With Lansweeper, you not only gain visibility into your server’s software inventory but also the tools to customize reports and charts, empowering informed decision-making for optimal IT management.
Windows Server Software Lansweeper On-Prem 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 Inner Join tblComputersystem On tblComputersystem.AssetID = tblAssets.AssetID Left Join tsysOS On tblAssets.OScode = tsysOS.OScode Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1 Group By tblSoftwareUni.softwareName, tblSoftware.softwareVersion, tblSoftwareUni.SoftwarePublisher Order By Total Desc