Installed Microsoft Office

[Nashterator]

Good day.

Is it possible to create a report that would show - the computer name,
the installed version of Microsoft Office (2016, 2019) and bit (x86 or x64)

Thank you

[Nashterator]

Thanks for Idea!

[KevinA-REJIS · Accepted solution]

Give this a try (it also has the software build): 

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion,
  Case
    When
      tblFileVersions.FilePathfull =
      'C:\Program Files\Microsoft Office\root\Office16\WINWORD.EXE' And
      tblFileVersions.Found = 1 Then '64-bit'
    When
      tblFileVersions.FilePathfull =
      'C:\Program Files (x86)\Microsoft Office\root\Office16\WINWORD.EXE' And
      tblFileVersions.Found = 1 Then '32-bit'
    When
      tblFileVersions.FilePathfull =
      'C:\Program Files\Microsoft Office 15\root\Office15\WINWORD.EXE'
      And tblFileVersions.Found = 1 Then '64-bit'
    When
      tblFileVersions.FilePathfull =
      'C:\Program Files (x86)\Microsoft Office 15\root\Office15\WINWORD.EXE' And
      tblFileVersions.Found = 1 Then '32-bit'
  End As 'Architecture',
  tsysOS.Image As icon
From tblAssets
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareUni.softwareName Like '%Microsoft Office%en-us%' And
  tblAssetCustom.State = 1 And ((tblFileVersions.FilePathfull =
      'C:\Program Files\Microsoft Office\root\Office16\WINWORD.EXE' And
      tblFileVersions.Found = 1) Or (tblFileVersions.FilePathfull =
      'C:\Program Files (x86)\Microsoft Office\root\Office16\WINWORD.EXE' And
      tblFileVersions.Found = 1) Or (tblFileVersions.FilePathfull =
      'C:\Program Files\Microsoft Office 15\root\Office15\WINWORD.EXE'
      And tblFileVersions.Found = 1) Or (tblFileVersions.FilePathfull =
      'C:\Program Files (x86)\Microsoft Office 15\root\Office15\WINWORD.EXE' And
      tblFileVersions.Found = 1))
Order By tblAssets.AssetName