→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
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.