→ 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: 
Daniel_B
Lansweeper Alumni
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]
0 REPLIES 0