→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kevinoie
Engaged Sweeper III
Hi.

Is it possible to get the code to run a report for all pc's on the network that have a version of microsoft office installed? I have tried to amend the original microsoft software report to ony return office versions but no success.

Many Thanks,

kevin
2 REPLIES 2
kevinoie
Engaged Sweeper III
Thats EXACTLY what I need. Thanks a million..
Hemoco
Lansweeper Alumni
Please try the report below:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName Like '%microsoft office%' And
tblSoftware.SoftwarePublisher Like '%microsoft%'
Order By tblComputers.ComputerUnique