This post helps you to get ConfigMgr Microsoft Edge SQL Query | Custom Report | SCCM. Let’s help to analyze the Edge browser installation using ConfigMgr Microsoft Edge 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 to use the edge chromium version instead of the legacy version. Let’s try to create a custom report for the Microsoft edge chromium-browser.
I have explained the process to install the edge version in the following guide. Deploy Microsoft Edge Browser Using SCCM ConfigMgr. Thanks to my colleague Kalateet Vyas to help with the following queries.
Learn how to create a device collection based on the MS Edge version -> Create MS Edge SCCM Device Collection Using WQL Query.
Manual or PowerShell Method to find Microsoft Edge Version
Let’s check the manual or automatic Method to find the version of Microsoft Edge. You can use PowerShell or a normal command prompt to get details of the MS Edge version.
There are two different ways to identify the version of the Microsoft Edge Browser application without using SCCM/ ConfigMgr. You can use the Registry to confirm the version. There are two options, Command Prompt and PowerShell commands to verify the MS Edge version details.
reg query HKCU\Software\Microsoft\Edge\BLBeacon /v version
(Get-ItemProperty -Path HKCU:\Software\Microsoft\Edge\BLBeacon -Name version).version
Custom Report for Legacy Edge Browser (NOT Supported version)
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 ConfigMgr Microsoft Edge SQL Query
Now let’s find out the edge version installation on Windows 10 devices. The MS Edge version of Microsoft edge installation happens only via force deployment of the 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. ConfigMgr | SCCM Microsoft Edge SQL Query.
Resources – ConfigMgr Microsoft Edge SQL Query
- Deploy Microsoft Edge Chromium Browser Using SCCM ConfigMgr
- Custom Report to check the Status of Predefined Site Maintenance Tasks
Author
Anoop is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is Blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.
How would you covert these queries to use them in a Device collection using a query?
Are you wanting a collection for all users with Chromium based Edge regardless of version? Or what specifically is the criteria for the collection you’re wanting?
Computers, not users……sorry