‎01-15-2013 02:44 PM
Select Top 1000000 upgrade_tblcomputers.Computername,
upgrade_tblcomputers.ComputerUnique,
upgrade_tblcomputers.Description,
upgrade_tblcomputers.Username,
upgrade_tblsoftware.SoftwarePublisher As Publisher,
upgrade_tblsoftware.softwareName As Software,
upgrade_tblsoftware.Lastchanged
From upgrade_tblcomputers
Inner Join upgrade_tblsoftware On upgrade_tblcomputers.Computername =
upgrade_tblsoftware.ComputerName
Inner Join upgrade_web40activecomputers On upgrade_tblcomputers.Computername =
upgrade_web40activecomputers.Computername
Where upgrade_tblsoftware.softwareName Like 'OpenOffice.org 2.%'
Order By upgrade_tblcomputers.Computername
‎01-15-2013 02:53 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now