‎06-13-2012 05:01 PM
‎06-14-2012 04:02 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description,
tblOperatingsystem.ServicePackMajorVersion As [Current SP],
tblComputers.Lastseen, Web40OSName.Compimage As icon
From tblOperatingsystem Inner Join
tblComputers On tblOperatingsystem.Computername = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername
Where tblComputers.Computername Not In (Select tblSoftware.ComputerName
From tblSoftware
Where tblSoftware.softwareName Like '%YourSoftware%') And Web40OSName.OSname =
'Win 7' And tblOperatingsystem.ServicePackMajorVersion <> '1'
Order By tblComputers.Computer
‎06-14-2012 08:34 AM
‎06-13-2012 05:02 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now