Get all Workstations with Internet Explorer 9 or 10 (WQL)

Purpose: Gather all workstations with Internet Explorer 9 or 10

Gathing all of the Internet Explorer versions across your domain will require one additional configuration. This configuration is a client side software inventory setting, where you set the SCCM client to search through all your workstations iexplorer.exe and fetch the version from the appointed file.

How to set SCCM to gather all of your Workstations Internet Explorer versions
#1 Administration\Overview\Client Settings
#2 Client Settings: Software Inventory Enabled
#3 Select Software Inventory
#4 iexplore.exe (for x86 Internet Explorer)
c:\Program Files (x86)\Internet Explorer\

iexplorer.exe (for x64 Internet Explorer)
c:\Program Files\Internet Explorer\

 

Get all Workstations with Internet Explorer 9
Limiting collection: All Workstations (with Client)
Resource Class: System Resource
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_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductVersion like “9.%” and SMS_G_System_SoftwareProduct.ProductName like “%Internet Explorer%”

 

Get all Workstations with Internet Explorer 10
Limiting collection: All Workstations (with Client)
Resource Class: System Resource
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_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductVersion like “10.%” and SMS_G_System_SoftwareProduct.ProductName like “%Internet Explorer%”

 

2 Thoughts on “Get all Workstations with Internet Explorer 9 or 10 (WQL)

  1. Hi,

    i’m trying to use the above settings but its not coming up with error “this query has a syntax error. are you sure you want to save it”?

    what is the error?

  2. Jyri Lehtonen on March 23, 2014 at 20:03 said:

    Hi Tom!

    If you copy paste the WQL-query from this website, it seems that you will get incorrect “quote” marks. You need to replace them in a notepad or such tool or manually in the query inputfield.

    Syntax errors are because of this mark => “

Leave a Reply

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


− two = one

Post Navigation