Windows Automatic Update Settings Audit

List Windows Automatic Update Settings

Find all Windows automatic update settings of your computers in the network. Windows update settings determine how and when automatic Windows updates are performed, this audit provides an overview of which setting each computer is using so that you can correct them where needed. With the filtering and sorting option you can easily find computers or specific automatic update settings and the computers that use them.

Windows update settings

Windows Automatic Update Settings Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Case tblRegistry.Value
    When '5' Then
      'Automatic Updates is required, but end users can configure it'
    When '4' Then 'Automatic download and scheduled installation'
    When '3' Then 'Automatic download and notify of installation'
    When '2' Then 'Notify before download'
    When '1' Then 'Never check for updates'
    Else 'Unknown, try rescanning the machine'
  End As UpdateSettings
From tblAssets
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tblRegistry On tblRegistry.AssetID = tblAssets.AssetID
Where tblState.Statename = 'Active' And tsysAssetTypes.AssetTypename In
  ('Windows', 'Windows CE') And tblRegistry.Valuename = 'auoptions'
Order By tblAssets.Domain,
  tblAssets.AssetName

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting