Recently a lot of people started migrating for the New Microsoft Edge Browser. Same happens in a lot of companies.
So there is the need to Check for Clients having the new Microsoft Edge based on Chromium installed on their Devices.
Within the Internet i found the Query executed directly on the MSSQL Database of an SCCM

MSSQL 
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'

But for sure I want the Query to work in the Configmanager Client to directly see the Resulst within my Querys. So I ended up on rewriting the Query to WQL and it worked.
The Final result is here:

MSSQL 
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, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version AS "Edge 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%"
and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "%appsense%"
Teilen:
LinkedIn X Mail
Max
Autor
Max

IT-Auditor by day, Homelab-Bastler by night. Ich baue, teste und dokumentiere – von Proxmox-Clustern über Smart-Home-Setups bis hin zu 3D-Druck. Wenn du Technik so liebst wie ich, bist du hier genau richtig.