Microsoft Office installations, without components

[Susan_A]

The report below lists the Microsoft Office installations in your network, without components like proofing tools, web components etc.

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

• The asset is a Windows computer.
  
• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once.
  
• The Software tab of the computer's Lansweeper webpage lists a software package whose name: starts with "Microsoft Office", ends in a year (e.g. 2000) and does not contain the word "viewer".

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.softwareName Like 'Microsoft Office%' And
  tblSoftwareUni.softwareName Not Like '%viewer%' And
  SubString(tblSoftwareUni.softwareName, Len(tblSoftwareUni.softwareName) - 4,
  3) = ' 20' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Software

[BeatleUy]

Thank you for this report, it is very helpful.

I have found an exception: "Microsoft Office Home and Business 2013 - en-us"

Is it possible to modify the report in order to include that?
Maybe looking for the year in the whole string not only at the end.

Best regards.