Windows Server Software Audit

Discover 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

Show

Hide