Windows: Windows automatic update settings (Built-in)

[Nick_VDB]

Added in v.6.0.100

The report below lists Windows computers and their Windows update setting.

The report will only list assets that meet all of the following criteria:

• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once
  
• The asset is a Windows computer.
  
• The registry value for Windows update setting has been scanned
  

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

[larbrevi]

Hi all

Zorry, solution probably posted earlier;
https://www.lansweeper.com/Forum/yaf_postst10737_Dashboard---windows-update.aspx#post40197

regards from Lars

[larbrevi]

Hi all

I'm having some issues With this report. It only says: This report has no results
I find it a bit strange as basically all my other reports are running fine. I have a small mix of win-xp, win7 and win10 machines.
I've tested creating it at least two times and that part Works fine.
I see one of the pre-reqs are: The registry value for Windows update setting has been scanned
Not 100% sure about this last one, whether I actually do it or not.

regards form Lars Brevik