Microsoft Edge report from SCCM

Question

Hi Team,

I am unable to get the MS edge data from SCCM database. I tried with "dbo.v_Add_REMOVE_PROGRAMS" & "dbo.v_GS_SoftwareFile" tables. But no luck. Could you help how to get edge report from SCCM.

Answer 1

If you don't have the Asset Intelligence for Installed Software enabled, you'll want to do so: https://learn.microsoft.com/en-us/mem/configmgr/core/clients/manage/asset-intelligence/configuring-asset-intelligence#steps-to-configure-asset-intelligence

Presuming that is done already, here's some some possible sql to get you started:

Select ist.ProductName0 as 'ProductName', ist.ProductVersion0 as 'ProductVersion', count(resourceid) as 'Count'
from v_gs_installed_software ist where ist.productname0 = 'Microsoft Edge'
group by ist.ProductName0, ist.Productversion0
order by 'Count' Desc

Select s1.netbios_name0 as 'ComputerName', ist.ProductName0 as 'ProductName', ist.Productversion0 as 'ProductVersion'
from v_gs_installed_software ist where ist.productname0 = 'Microsoft Edge'
and ist.ProductVersion0 = '90.0.818.62'

Answer 2

Do you have AI inventory enabled? if so it is collected via it.