Windows: Internet Explorer file version (Built-in)

[Daniel_B]

The report below lists Windows computers with Internet Explorer executable details. For scanning purposes, the executable needs to be set for scanning under Configuration\Custom Scanning.

The report will only list assets that meet all of the following criteria:

• The asset state is set to "active".
  
• The asset has been successfully scanned at least once.
  
• The asset is a Windows computer.
  
• The Internet Explorer executable is present under the defined folder path.

Select 
 Top 1000000 tblAssets.AssetID,
 tblAssets.AssetName,
 tblAssets.Domain,
 tblAssets.Username,
 tblAssets.Userdomain,
 Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
 tblAssets.IPAddress,
 tsysIPLocations.IPLocation,
 tblAssetCustom.Manufacturer,
 tblAssetCustom.Model,
 tsysOS.OSname As OS,
 tblAssets.SP,
 tblAssets.Lastseen,
 tblAssets.Lasttried, 
 tblfileversions.Found, 
 tblfileversions.FilePathfull, 
 tblfileversions.FileVersion, 
 tblfileversions.CompanyName, 
 tblfileversions.Filesize, 
 tblfileversions.Lastchanged AS [Files last changed]
From tblassets 
 Inner Join tblfileversions On tblassets.AssetID = tblfileversions.AssetID 
 Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
 Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
 Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID 
 Inner Join tblState On tblState.State = tblAssetCustom.State
 Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblfileversions.FilePathfull Like '%iexplore.exe' And tblState.Statename = 'Active' 
Order By tblAssets.Domain, tblAssets.AssetName