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