cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Nick_VDB
Champion Sweeper III
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
2 REPLIES 2
larbrevi
Engaged Sweeper
Hi all

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

regards from Lars
larbrevi
Engaged Sweeper
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