Pull Registry Data

[kdelaughder]

Good morning,

I created a report a few years back that pulled the IE version from the key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer" looking at value name "Version" and had no problems. Now that IE 11 has their version info stored in svcVersion I created a new report from a copy of the old one and simply changed the value name to "svcVersion" but it will not pull the data for 11.%

Below is the script. Does anyone see anything wrong with it or why it wouldn't pull data?

Select Top 1000000 upgrade_tblComputers.Computer,
  upgrade_tblRegistry.Value,
  tblADusers.Displayname,
  tblADusers.Title,
  tblADusers.Office,
  upgrade_tblComputers.Computername
From upgrade_tblComputers
  Inner Join upgrade_tblRegistry On upgrade_tblComputers.Computername =
    upgrade_tblRegistry.Computername
  Inner Join tblADusers On upgrade_tblComputers.Username = tblADusers.Username
    And upgrade_tblComputers.Userdomain = tblADusers.Userdomain
  Inner Join upgrade_web40ActiveComputers On upgrade_tblComputers.Computername =
    upgrade_web40ActiveComputers.Computername
  Inner Join upgrade_tblOperatingsystem On upgrade_tblComputers.Computername =
    upgrade_tblOperatingsystem.Computername
Where upgrade_tblRegistry.Value Like '11.%' And upgrade_tblRegistry.Regkey =
  'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer' And
  upgrade_tblRegistry.Valuename = 'svcVersion'
Order By upgrade_tblComputers.Computer

[kdelaughder]

This helped me tremendously! Thank you for your help!

[Daniel_B · Accepted solution]

1. Your report uses a lot of table names which are not existing in the Lansweeper database. You need to use the table names as you find them in the report builder and in the database dictionary (which is avaiable from Lansweeper version 5.2).

2. In order to report about registry values, first you need to set up the scan of this value. Go to Configuration\Custom Scanning, section Registry Scanning, hit Add registry key to scan and enter the key path and value to scan. Then scan all your assets again. After the scan completed, you can report on its result. In order to report on this key, you could either use the Report link on the Configuration\Custom scanning page next to the key you entered, or you create a custom report like this:

Select Top 1000000 tblAssets.AssetID,
  tblRegistry.Value,
  tblADusers.Displayname,
  tblADusers.Title,
  tblADusers.Office,
  tblAssets.AssetName
From tblAssets
  Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
  Inner Join tblADusers On tblAssets.Username = tblADusers.Username And
    tblAssets.Userdomain = tblADusers.Userdomain
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblRegistry.Value Like '11.%' And tblRegistry.Regkey =
  'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer' And
  tblRegistry.Valuename = 'svcVersion' And tblAssetCustom.State = 1
Order By tblAssets.AssetName

3. The Internet Explorer file version can also be read by file scanning. In the current release of Lansweeper, there is a built-in report called Files: Internet explorer version, which shows you exactly what you are looking for.