Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bostjanc
Engaged Sweeper III
Is there a way on Lansweeper Dashboard to get information regarding clients Windows update status?
We would like to be informed if anyone has put Windows updates ON/OFF.
With best regards,
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
This is not scanned by default. You could you custom registry scanning in order to scan these values on target computer's registry:

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update, Value AUOptions
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update, Value NoAutoUpdate

For details on the values stored in this registry key, have a look at this Microsoft page.

After setting up Lansweeper to scan these values, you could generate a report like the following which lists the auto update status on your computers. On your Dashboard, add a Data Report Widget and let it display this report.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case tAUOptions.Value When 2 Then 'notify before download'
When 3 Then 'automatically download and notify of installation'
When 4 Then 'automatic download and scheduled installation'
When 5 Then 'automatic updates is required, but end users can configure it'
Else 'unkown' End As [AU options],
Case tNoAutoUpdate.Value When 1 Then 'disable automatic updates'
When 0 Then 'enable automatic updates' Else 'unkown' End As [No auto-update]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'auoptions') tAUOptions
On tblAssets.AssetID = tAUOptions.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'noautoupdate') tNoAutoUpdate
On tblAssets.AssetID = tNoAutoUpdate.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1

View solution in original post

2 REPLIES 2
bostjanc
Engaged Sweeper III
thank you for your reply.
with best regards
Daniel_B
Lansweeper Alumni
This is not scanned by default. You could you custom registry scanning in order to scan these values on target computer's registry:

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update, Value AUOptions
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update, Value NoAutoUpdate

For details on the values stored in this registry key, have a look at this Microsoft page.

After setting up Lansweeper to scan these values, you could generate a report like the following which lists the auto update status on your computers. On your Dashboard, add a Data Report Widget and let it display this report.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case tAUOptions.Value When 2 Then 'notify before download'
When 3 Then 'automatically download and notify of installation'
When 4 Then 'automatic download and scheduled installation'
When 5 Then 'automatic updates is required, but end users can configure it'
Else 'unkown' End As [AU options],
Case tNoAutoUpdate.Value When 1 Then 'disable automatic updates'
When 0 Then 'enable automatic updates' Else 'unkown' End As [No auto-update]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'auoptions') tAUOptions
On tblAssets.AssetID = tAUOptions.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'noautoupdate') tNoAutoUpdate
On tblAssets.AssetID = tNoAutoUpdate.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now