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