Chrome File Version (Built-in)

[Daniel_B]

Report on computers with file version of chrome.exe
Prerequisite: Full path of chrome.exe has been set for scanning under Configuration\Custom scanning


Meets all the following criteria:
- Active asset
- Windows asset
- chrome.exe was scanned in the past

Sorted on:
- Asset UID
- Chrome.exe file path

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tblFileVersions.Found,
  tblFileVersions.FilePathfull,
  tblFileVersions.FileVersion,
  tblFileVersions.CompanyName,
  tblFileVersions.Filesize,
  tblFileVersions.CreationDate,
  tblFileVersions.LastAccessed,
  tblFileVersions.LastModified,
  tblFileVersions.Lastchanged
From tblAssets
  Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblFileVersions.FilePathfull Like '%chrome.exe'
Order By tblAssets.AssetUnique,
  tblFileVersions.FilePathfull