Report of missing reg key

[eyalg]

Hello,

I'm trying to write a report that display all the computer that doesn't have a specific regkey of WSUS.

I allready done a report that show me all the computer that have that key.

Please help

Arnon

[Hemoco]

Haven't completely tested if but should be something like this:

Select tblComputers.Computername, tblComputers.ComputerUnique, temptbl.Regkey,
  temptbl.Valuename        
From (Select tblComputers.Computername, tblComputers.ComputerUnique,
      tblRegistry.Regkey, tblRegistry.Valuename, tblRegistry.Value
    From tblComputers Inner Join
      tblRegistry On tblComputers.Computername = tblRegistry.Computername
    Where tblRegistry.Regkey Like '%windowsupdate%') temptbl Right Join
  tblComputers On tblComputers.Computername = temptbl.Computername

[eyalg]

here is one line from the tblregistry
<comp name> Windows XP Professional http://10.x.x.x:8530 <user name> HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate

lansweeper collects only from computers that got this key.
I wan't that the report will divide the computers that apear in my report from all the computers that are in my lansweeper database.

Thanks ,

Arnon

[Hemoco]

Can you post an extract of the tblregistry output for this please.