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) |
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%” |
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?
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 => “