‎12-29-2014 11:57 AM
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]
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now