Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Untag as favorite
How to create a report of a registry key scanned
Options
Previous Topic Next Topic
ejensen
#1 Posted : Friday, February 03, 2012 9:47:05 PM

Rank: Premium user

Groups: Premium Users, Member
Posts: 45
Location: Ohio, USA
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. Think

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?
Back to top
Lansweeper
#2 Posted : Tuesday, February 07, 2012 2:35:24 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,379
An example registry report can be found on pages 89-90 of our online documentation. 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.
Back to top
ejensen
#3 Posted : Monday, February 13, 2012 9:35:09 PM

Rank: Premium user

Groups: Premium Users, Member
Posts: 45
Location: Ohio, USA
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.
Back to top
Lansweeper
#4 Posted : Tuesday, February 14, 2012 2:50:26 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,379
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.

Quote:
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
Back to top
| Edit by user
ejensen
#5 Posted : Wednesday, February 15, 2012 9:37:13 PM

Rank: Premium user

Groups: Premium Users, Member
Posts: 45
Location: Ohio, USA
I think you got it. :D Thank you!
Back to top
Users browsing this topic
Guest
Untag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba