→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kdelaughder
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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.

View solution in original post

2 REPLIES 2
kdelaughder
Engaged Sweeper
This helped me tremendously! Thank you for your help!
Daniel_B
Lansweeper Alumni
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.