Internet Explorer version count

[Daniel_B]

List of Internet Explorer main versions installed, with numbers of installation for each version

Pre-requisite: File scanning set up under Configuration\Custom scanning for

• %programfiles(x86)%\internet explorer\iexplore.exe

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

Sorted on:
- IE version

Select Top 1000000 tblFV1.FV As [IE Version],
  Count(tblAssets.AssetID) As Count
From tblAssets
  Inner Join (Select tblFileVersions.AssetID,
    tblFileVersions.Found,
    tblFileVersions.FilePathfull,
    SubString(tblFileVersions.FileVersion, 1, CharIndex('.',
    tblFileVersions.FileVersion) - 1) As FV
  From tblFileVersions) tblFV1 On tblAssets.AssetID = tblFV1.AssetID
Where tblFV1.FilePathfull Like '%iexplore.exe' And tblFV1.Found = 1 And
  tblAssets.Assettype = -1
Group By tblFV1.FV
Order By [IE Version]