Report Based on Registry Keys

[Trystan]

Hello,

I've managed to follow successfuly the guidence on creating a report based on a custom registry key that i've entered into the regisitry scanning, the problem is that under the field regvalue I have multiple entries with the same name (DisplayVersion)

Following the guide found under http://www.lansweeper.com/kb/18/report-based-on-registry-keys.html

I have generating a report using the following:

Select Top 1000000 upgrade_tblcomputers.Computername,
upgrade_tblcomputers.ComputerUnique,
upgrade_tblcomputers.Domain,
upgrade_tblregistry.Valuename,
upgrade_tblregistry.Value
From upgrade_tblcomputers
Inner Join upgrade_tblregistry On upgrade_tblcomputers.Computername =
upgrade_tblregistry.Computername
Where upgrade_tblregistry.Valuename = 'DisplayVersion'

The problem is that under the custom scanned registry keys there are two with the same key value called DisplayVersion

I'm just learning the correct syntax to use, how can I use the correct 'DisplayVersion' scanned registry value for the report?

The two registry scanned value locations are below, it is the second one I wish to report on

SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\A02B29B991A6F824B80D25FD58B9C116\InstallProperties

SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\1BF329998847C4249498230FA67161B3\InstallProperties

I can see under the Scanned Info that the scanned key is called Registry4, can I generate a report based on this?
Thank you for any help you can offer!

[Hemoco]

A sample report can also be found on page 99 of our online documentation.

[Trystan]

OK i've managed to achieve what I wanted by using the following SQL statement:

Select Top 1000000 upgrade_tblComputers.ComputerUnique,
upgrade_tblComputers.Domain,
upgrade_tblRegistry.Valuename,
upgrade_tblRegistry.Value,
upgrade_tblRegistry.Regkey,
upgrade_tblComputers.Computername,
upgrade_tblRegistry.RegistryID
From upgrade_tblComputers
Inner Join upgrade_tblRegistry On upgrade_tblComputers.Computername =
upgrade_tblRegistry.Computername
Where
upgrade_tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\1BF329998847C4249498230FA67161B3\InstallProperties'

I would be curious to know if there are other ways of achieving this or what others are doing. 🙂