PCs without IE 8

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’

Published
Jul 19 2010, 07:08 AM
by
Garth

Filed under: SQL, SMS, Code, System Center, ConfigMGr, vNext

Leave a Reply

Your email address will not be published. Required fields are marked *