→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
gforchuk
Engaged Sweeper
Good afternoon,

I have been asked to look into whether or not Lansweeper can deliver a report on which Windows systems in our domain currently have Windows Updates enabled. I searched through the forums for this topic but could not find anything specific.

Does anyone know if Lansweeper can do this and/or how to produce this report?

Any help is greatly appreciated.

Thank you,
G
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
We posted a note about this on our Facebook page: https://www.facebook.com/notes/lansweeper/use-registry-scanning-to-check-windows-update-settings/475326995821735

In short, do the following:
• Add the registry scan below under Configuration/Scanning Setup/Custom Scanning.
Rootkey: HKEY_LOCAL_MACHINE
RegPath: SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update
RegValue: AUOptions

• Rescan your computers by clicking the Assets link at the top of the web console, ticking the upper checkbox and hitting the Rescan button on the left.
• Run the report below.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
Case UpdateCheck.Value When '4' Then 'download and install automatically'
When '3' Then 'ask before installing'
When '2' Then 'ask before downloading or installing'
When '1' Then 'never check for updates'
Else 'unknown, try rescanning the machine' End As UpdateSettings
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select tblRegistry.AssetID,
tblRegistry.Valuename,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename = 'auoptions') UpdateCheck
On UpdateCheck.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

To use the report above, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.

View solution in original post

2 REPLIES 2
gforchuk
Engaged Sweeper
Thank you very much for the assistance. This report was perfect.
Hemoco
Lansweeper Alumni
We posted a note about this on our Facebook page: https://www.facebook.com/notes/lansweeper/use-registry-scanning-to-check-windows-update-settings/475326995821735

In short, do the following:
• Add the registry scan below under Configuration/Scanning Setup/Custom Scanning.
Rootkey: HKEY_LOCAL_MACHINE
RegPath: SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update
RegValue: AUOptions

• Rescan your computers by clicking the Assets link at the top of the web console, ticking the upper checkbox and hitting the Rescan button on the left.
• Run the report below.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
Case UpdateCheck.Value When '4' Then 'download and install automatically'
When '3' Then 'ask before installing'
When '2' Then 'ask before downloading or installing'
When '1' Then 'never check for updates'
Else 'unknown, try rescanning the machine' End As UpdateSettings
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select tblRegistry.AssetID,
tblRegistry.Valuename,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename = 'auoptions') UpdateCheck
On UpdateCheck.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

To use the report above, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.