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 ScanningMeets 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