Microsoft WSUS Server Installed

Identify WSUS Servers in Your Network

Discover and list all servers in your network which are running Windows Server Update Services (WSUS), previously known as Software Update Services (SUS). These servers are used for administration, management and deployment of Microsoft products, updates, hotfixes and more in corporate environments. The report provides a list of all WSUS servers in your network so you can easily identify which servers are performing these tasks and target them more specifically for other analyses.

Microsoft WSUS Server Installed Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tblAssets.Description,
  tblServices.Lastchanged,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
  Inner Join tblServicesUni On tblServices.ServiceuniqueID =
    tblServicesUni.ServiceuniqueID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblServicesUni.Name = N'wsusservice' And tblAssetCustom.State = 1
Order By tblAssets.AssetName

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting