/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Internet Explorer 6 Report

06/04/2013 2810 views

Can anyone help me with creating a SCCM report that lists all machines in a collections that have IE 6 installed? Or if it's easier to create a collection that does the same thing would be good enough too.

0 Comments   [ + ] Show comments

Comments


All Answers

3

You can create a query based collection. This assumes that , you have enabled software inventory client agent and by default, *.exe is listed:

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = 'iexplore.exe' and SMS_G_System_SoftwareFile.FilePath like '%prog%internet%' and SMS_G_System_SoftwareFile.FileVersion like '6.%'

Answered 06/04/2013 by: SnowLyric
Second Degree Brown Belt

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ