‎02-01-2012 03:10 PM
‎02-01-2012 04:41 PM
‎02-01-2012 04:22 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now