Powershell to get all the application name from SCCM server WMI

Get-WmiObject -ComputerName Primary_server_name -Namespace root\sms\site_Sitecode -Class sms_applicationlatest | select localizeddisplayname



Primary_server_name replace it with primary server name
Sitecode replace it with the Site code Example ABC

SCCM SQL Report to extract list of machines based on ARP entry by its name on specific collection

Select v_R_System.Name0 AS System_Name,

v_Add_Remove_Programs.DisplayName0 AS Display_Name, 

v_Add_Remove_Programs.Publisher0 AS Publisher, 

v_Add_Remove_Programs.Version0 AS Version, 

v_Add_Remove_Programs.prodID0 AS Product_ID, 

CASE

        WHEN b.OSLanguage0 in (1033) THEN 'English'

        WHEN b.OSLanguage0 in (1036) THEN 'French'

        Else 'Unknown'

END as 'OS_language', v_R_System.User_name0 AS User_Name

FROM v_Add_Remove_Programs

JOIN  v_R_System ON v_Add_Remove_Programs.ResourceID = v_R_System.ResourceID

join v_gs_Operating_system b on v_R_System.resourceid=b.resourceid

JOIN v_FullCollectionMembership fcm on v_Add_Remove_Programs.ResourceID=fcm.ResourceID

WHERE  fcm.CollectionID ='CollectionID' and v_Add_Remove_Programs.DisplayName0 like '%ARP Name %'