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

http://it.peikkoluola.net/2014/01/10/get-all-workstations-with-internet-explorer-9-or-10-wql/

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

January 10, 2014 09:00 ⋅ 2 Comments ⋅ Jyri Lehtonen

Share this post on:

Reddit Stumble Pinterest foursquare Digg Diigo Evernote Tumblr Instapaper Pocket Sonico Netlog Vkontakte Hyves Xing Mail.ru Weibo Yahoo Mail Gmail Hotmail AOL Mail Myspace  Page has been shared successfully.

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%”