ConfigMgr Custom Report for Chrome Browser | SCCM | SQL Query

0
ConfigMgr Custom Report for Chrome Browser

Let’s help to analyze the Google Chrome browser installation using ConfigMgr. ConfigMgr Custom Report for Chrome Browser. Also, try to find out the chrome browser installation using SCCM.

Let’s try to create a custom report to find google chrome versions installed on Windows 10 devices. You don’t need to enable software inventory to get the inventory of chrome browser installation.

Related post Deploy Google Chrome Update with SCCM Step by Step Guide.

Custom Report for Chrome Browser

Let’s find out the chrome browser installed on Windows 10 devices. The following steps shall help you to create a custom report for chrome browsers.

  • Open the SQL Management Studio.
  • Click on the New Query button.
  • Select the CM_MEM database from the drop-down menu.
    • MEM is the ConfigMgr site code.
ConfigMgr Custom Report for Chrome Browser | SCCM | SQL Query
ConfigMgr Custom Report for Chrome Browser | SCCM | SQL Query
  • Copy the following SQL query to find the Chrome browser.
  • Click on the Execute button.
Select Distinct
v_R_System.Name0 as 'machine',
v_R_System.User_Name0 as 'username',
v_R_System.AD_Site_Name0 as 'Location',
v_R_System.Resource_Domain_OR_Workgr0 as 'Domain',
v_Add_Remove_Programs.DisplayName0 as 'displayname',
v_Add_Remove_Programs.Version0 as 'Version'
From v_R_System
Join v_Add_Remove_Programs on v_R_System.ResourceID = v_Add_Remove_Programs.ResourceID 
Where v_Add_Remove_Programs.DisplayName0 Like '%Google Chrome%'
and v_Add_Remove_Programs.DisplayName0 not Like '%update%'
and v_R_System.Active0 = '1'
  • Let’s find the results of the query.
ConfigMgr Custom Report for Chrome Browser SQL query
ConfigMgr Custom Report for Chrome Browser – SQL Query

Results – ConfigMgr Custom Report for Chrome Browser

MachineUser NameLocation Domain Display NameChrome Version
PROD-WIN20 NULLDefault-First-Site-NameMEMCMGoogle Chrome83.0.4103.106
Chrome browser custom report – ConfigMgr Custom Report for Chrome Browser
ConfigMgr Custom Report for Chrome Browser | SCCM | SQL Query 1
ConfigMgr Custom Report for Chrome Browser – SQL Query

Resources

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.