→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
List of computers with Internet Explorer version information

Pre-requisite: Scanning the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer, RegValue Version, is enabled under Configuration\Custom Scanning


Meets all the following criteria:
- Active asset
- Windows asset
- Internet Explorer installed

Sorted on:
- Asset name


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblAssets
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Regkey Like '%internet explorer' And tblAssets.Assettype = -1
Order By tblAssets.AssetName
1 REPLY 1
brican847
Engaged Sweeper II
Thanks for sharing, so simple to understand and it works.