How to create a report of a registry key scanned

[ejensen]

Ok, I tried to figure this out but I'm not sure if its hard to do this or I'm just having Friday burnout.

I setup our lansweeper to scan the registry for a key called "AutoConfigURL" which is what we use for our proxy configuration.

What I would like is a report of all computers and show me the value of this key.

There is a slight catch though... that registry key does not always exist (if user deleted it for example).

So I need something like this:

computer key value
office1 yes blahblah
office2 yes blahblah
office3 yes NULL
office4 no NULL
office5 yes blahblah
office6 yes NULL

Can anyone help me with this report?

[ejensen]

I think you got it. 😄 Thank you!

[ejensen]

thanks, but that really didnt help.
I need a report of all users and if the registry key does not exists and if it does exists, then what that value is.

[Hemoco · Accepted solution]

ejensen wrote:
thanks, but that really didnt help.
I need a report of all users and if the registry key does not exists and if it does exists, then what that value is.

Please have a look at the example report below.

- All computers are listed in this report.
- Only those where the specified registry key could be found have an entry for the "Regkey" field.
- Only those where a value was found for the specified registry key have an entry for the "Value" field.

Select Top 1000000 tblComputers.Computername, tblComputers.Domain, tblComputers.Computer, tblComputers.Username, scndtbl.Regkey, scndtbl.Valuename, scndtbl.Value From tblComputers Left Join (Select tblRegistry.Regkey, tblRegistry.Valuename, tblRegistry.Value, tblRegistry.Computername From tblRegistry Where tblRegistry.Regkey = 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer' And tblRegistry.Valuename = 'Version') scndtbl On tblComputers.Computername = scndtbl.Computername Order By tblComputers.Domain, tblComputers.Computer

[Hemoco]

An example registry report can be found in our Knowledge Base. If you create a report following this format, computers where the registry key could not be found will not be included in the report results.