ConfigMgr Microsoft Edge Chromium SQL Query | Custom Report | SCCM

Let’s help to analyze the Edge chromium-browser installation using ConfigMgr Microsoft Edge Chromium SQL Query. Also, try to find out the legacy Microsoft Edge browser installation using SCCM.

Microsoft introduced the new version of Edge based on chromium. It’s recommended using the edge chromium version instead of the legacy version. Let’s try to create a custom report for Microsoft edge chromium-browser.

I have explained the process to install the edge chromium version in the following guide. Deploy Microsoft Edge Chromium Browser Using SCCM ConfigMgr. Thanks to my colleague Kalateet Vyas to help with the following queries.

Custom Report for Legacy Edge Browser

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

NOTE! – Software Inventory should be to collect legacy edge file details and create the following report.

• 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.

• Copy the following SQL query to find the Legacy version of Edge.
• Click on the Execute button.

SELECT distinct
A.ApplicationName0,
A.Version0,
O.Caption0 as 'Operating System Name',
RS.Name0 as 'machine',
RS.User_Name0 as 'username',
RS.AD_Site_Name0 as 'Location',
RS.Resource_Domain_OR_Workgr0 as 'Domain'

 FROM v_GS_WINDOWS8_APPLICATION A
 JOIN v_GS_WINDOWS8_APPLICATION_USER_INFO AU ON A.FullName0 = AU.FullName0
 JOIN v_R_System RS ON A.ResourceID = RS.ResourceID
 JOIN v_GS_OPERATING_SYSTEM O ON RS.ResourceID = O.ResourceID

 where A.ApplicationName0 like '%MicrosoftEdge%'
and O.Caption0 not like '%Server%'
and O.Caption0 not like '%8.1%'
and O.Caption0 not like '%Embedded%'
and RS.Active0 = '1'
and RS.Client0 = '1'

• Let’s find the results of the query.

Custom Report for Microsoft Edge Chromium Browser

Now let’s find out the edge chromium version installation on Windows 10 devices. The chromium version of Microsoft edge installation happens only via force deployment of application.

• 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.

• Copy the following SQL query to find the Legacy version of Edge.
• Click on 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 '%Microsoft Edge%'
and v_Add_Remove_Programs.DisplayName0 not Like '%update%'
and v_Add_Remove_Programs.DisplayName0 not Like '%appsense%'
and v_R_System.Active0 = '1'

• Let’s find the results of the query.

Resources – ConfigMgr Microsoft Edge Chromium SQL Query

• Creating custom report models for Configuration Manager in SQL Server Reporting Services
• Deploy Microsoft Edge Chromium Browser Using SCCM ConfigMgr
• Custom Report to check the Status of Predefined Site Maintenance Tasks