SCCM Query for Browsers

by

Here are my SCCM queries for all the browsers.

Firefox SCCM Query

select SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ClientType, SMS_G_System_INSTALLED_SOFTWARE.ProductName from  SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "%firefox%"

Chrome SCCM Query:

select SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ClientType, SMS_G_System_INSTALLED_SOFTWARE.ProductName, SMS_G_System_INSTALLED_SOFTWARE.ProductVersion from  SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Google Chrome"

Edge Legacy:

select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.operatingSystem, SMS_G_System_WINDOWS8_APPLICATION.ApplicationName, SMS_G_System_WINDOWS8_APPLICATION.Version from  SMS_R_System inner join SMS_G_System_WINDOWS8_APPLICATION on SMS_G_System_WINDOWS8_APPLICATION.ResourceId = SMS_R_System.ResourceId where SMS_G_System_WINDOWS8_APPLICATION.ApplicationName = "Microsoft.MicrosoftEdge"

Edge Chromium

select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Microsoft Edge%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "%update%"

IE

For IE it is a bit complicated, as we have to customize the hardware inventory to add the IE registry version check, please refer to this https://tcsmug.org/blogs/sherry-kissinger/330-internet-explorer-version-information-via-hardware-inventory

select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_G_System_IExplorerVer.Version, SMS_G_System_IExplorerVer.svcVersion, SMS_G_System_IExplorerVer.svcKBNumber from  SMS_R_System inner join SMS_G_System_IExplorerVer on SMS_G_System_IExplorerVer.ResourceID = SMS_R_System.ResourceId

Leave a Comment