SCCM QUERY TO FIND INSTALLED APPLICATION FROM "ADD OR REMOVE PROGRAMS" - SCCM 2012

Select DISTINCT SYS.Netbios_Name0,SYS.Resource_Domain_OR_Workgr0,SP.DisplayName0, SP.Publisher0, SP.Version0, SP.InstallDate0
from  v_Add_Remove_Programs sp
JOIN v_R_System SYS ON SP.ResourceID=SYS.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID = 'SMS00001'
ORDER By SYS.Netbios_Name0, SP.DisplayName0, SP.Publisher0, SP.Version0, SP.InstallDate0


Note: 'SMS00001' is All systems collection ID, you can change to any other collections ID and generate the report.