Prefacing this with I am a Lansweeper newbie and trying to clean up a bit of a mess. I'm trying to run a report for Microsoft Office versions and I am noticing a lot of machines have remnants of older versions and showing up on the report, for instance:
hostname1 Microsoft Office Professional Plus 2007
hostname1 Microsoft Office Professional Plus 2016
Ideally, I would like my report to only show the newest, so in this case:
hostname1 Microsoft Professional Plus 2016
Here's what I've been playing around with thus far:
Select Top 1000000 tblAssets.AssetName As [Computer Name],
tblSoftwareUni.softwareName As [Software Name],
tblSoftware.softwareVersion As Version
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.softwareName Like 'Microsoft Office Professional Plus%'
And tblAssets.IPAddress Like '10.10%')
Order By [Computer Name]
I could further manipulate this data in Excel, but would like to have it on a custom dashboard.
Not sure how to best accomplish.
Appreciate your ideas.
