finding out computer GPO settings

[alpinelegend]

Hi,

I need to get a report that will tell me the local GPO settings for our machines.

I am looking to find out the value of the following:

Local computer policy>computer configuration>administration templates>windows components>windows update>"specify intranet Microsoft update service location"

Is it possible to get a report that can scan for this setting on all the machines?

Thanks

[alpinelegend]

Thanks for that!

I have come up with the following report based on this:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblRegistry.Valuename, tblRegistry.Value From tblComputers Inner Join tblRegistry On tblComputers.Computername = tblRegistry.Computername Where tblRegistry.Valuename = 'WUServer'

This report gives me a list of all machines that have this value in the registry which is great. But i also want it to tell me all the machines that do not have this value.

is this possible?

Thanks

[Hemoco · Accepted solution]

alpinelegend wrote:
This report gives me a list of all machines that have this value in the registry which is great. But i also want it to tell me all the machines that do not have this value.

You can use something similar to the report below. This report lists all computers. Only those where the specified registry value could be found will have entries for the tblRegistry fields.

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique As
[Computer Name], RegistryScan.Regkey, RegistryScan.Valuename,
RegistryScan.Value, RegistryScan.Lastchanged
From tblComputers Left Join
(Select tblRegistry.Computername, tblRegistry.Regkey, tblRegistry.Valuename,
tblRegistry.Value, tblRegistry.Lastchanged
From tblRegistry
Where tblRegistry.Valuename = 'WUServer') RegistryScan On
RegistryScan.Computername = tblComputers.Computername
Order By tblComputers.ComputerUnique

[Salamine]

I don't think Lansweeper scans this. But it is possible by adding it to the registry scan.

Sever
HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\WUServer

Statistics Server
HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\WUStatusServer

Enabled or Disabled
HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU\UseWUServer

-Sal