Report with Multiple Software Fields

[jltice]

We are currently in the process of removing all previous versions of MS Office except 2016. Is there a way to run a report that will show all assets with any prior versions of MS Office installed and have it show which prior versions are installed? Some of our computers have MS Office 2013, a few have MS Office 2010 and a very select few still seem to have MS Office 2007 installed. We also need to locate who has previous versions of MS Visio and MS Project.

[AZHockeyNut]

Not sure how close this will get you but have a go.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblSoftwareUni.softwareName Like '%microsoft office%' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version