Community FAQ
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

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now