→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Rick_B
Engaged Sweeper
Hi - Does anyone have a working report that will pull out Microsoft Store components that would highlight the HEVC codecs as detailed in CVE-2020-1425 & CVE-2020-1457. We can get some results from SCCM running the following query but I'm struggling to try and get the same info from Lansweeper.

SELECT distinct
A.ApplicationName0
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
order by ApplicationName0

SELECT distinct
RS.Name0,
A.ApplicationName0
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
where ApplicationName0 like '%hevc%' order by Name0

Thanks
Richard
0 REPLIES 0