SCCM query to check if any device is running IE 6, 7 or 8

Used the following SCCM query to check if any device is running IE 6, 7 or 8.

SELECT DISTINCT
sys.Name0 AS 'Computer Name',
-- sys.* ,
sf.FileName AS 'File Name',
sf.FileVersion AS 'IE Version',
sf.FilePath AS 'File Path'
FROM
v_GS_SYSTEM sys
INNER JOIN v_GS_SoftwareFile sf ON sys.ResourceID = sf.ResourceID
WHERE
sf.FileName = 'iexplore.exe'
AND (sf.FileVersion LIKE '6.%' OR sf.FileVersion LIKE '7.%' OR sf.FileVersion LIKE '8.%')
ORDER BY
sys.Name0, sf.FileVersion
;

Leave a Reply

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