PCs without IE 8
select Distinct
CS.Name0
from
dbo.v_GS_COMPUTER_SYSTEM CS
left outer join dbo.v_GS_SoftwareFile SF on CS.ResourceID = SF.ResourceID
where
SF.ResourceID not in (select Distinct ResourceID from dbo.v_GS_SoftwareFile where FileName = ‘iexplore.exe’ and FileVersion like ‘8.%’)
and FileName = ‘iexplore.exe’