SCCM Report for all installed applications for a collection

This report is a simplified version of in build  Software 01A - Summary of installed software in a specific collection.
In this report we can get software title, Software version and number of instances installed in that collection.
********************************************************************
SELECT  A.DisplayName0, A.Version0, Count(*) AS 'Count'

FROM v_GS_ADD_REMOVE_PROGRAMS A, v_GS_COMPUTER_SYSTEM B, v_FullCollectionMembership C

WHERE A.ResourceID = B.ResourceID
    AND A.ResourceID = C.ResourceID
    AND A.DisplayName0 NOT LIKE 'Hotfix for %'
    AND A.DisplayName0 NOT LIKE 'Security Update for %'
    AND A.DisplayName0 NOT LIKE 'Update %'
    AND CollectionID = @collection

GROUP BY A.DisplayName0, A.Version0
ORDER BY A.DisplayName0
********************************************************************
More SCCM custom reports can be found here