Installed software's report for the collection ID

Installed software's report for the collection ID :-

Declare @CollID char(8)      
Set @CollID = 'ING00898'  
SELECT Distinct
COMP.Name0 AS 'Machine Name',      
 COMP.UserName0 AS 'Username',
 v_R_system.User_Domain0 AS ' Domain Name',

COMP.Manufacturer0 AS 'Make',      
 COMP.Model0 AS 'Model',      
COMP.SystemType0 AS 'Architecture',    
COMP.TotalPhysicalMemory0/1024 AS 'RAM',      
 ARP.Publisher0 AS 'Publisher',      
ARP.DisplayName0 AS 'Program',    
ARP.Version0 AS 'Version',      
ARP.InstallDate0 AS 'Install Date',    
 ARP.ProdID0 AS 'Product ID'

FROM v_Add_Remove_Programs ARP      
JOIN v_FullCollectionMembership FCM            
on ARP.ResourceID = FCM.ResourceID      
JOIN v_GS_COMPUTER_SYSTEM COMP          
on ARP.ResourceID = COMP.ResourceID
JOIN v_R_System on v_R_System.ResourceID = ARP.ResourceID      
WHERE FCM.CollectionID = @CollID          
AND ARP.DisplayName0 IS NOT NULL          
AND ARP.ProdId0 NOT LIKE '%(KB%)%'          
AND ARP.DisplayName0 NOT LIKE '%Update%'