Looking for a report that shows a list of all software installed on systems in a collection that filters out the usual suspects MS, Adobe, etc. so I only see the non baseline types. Would be nice if it could show the number of instances of each app, which I could then drill down to see which systems have it installed.

Try this query. Replace the correct Collection ID in place of 'sms000ds'. You can also add up the software wildcard names in the query you would like to filter

Select b.Name0, 
a.DisplayName0, A.InstallDate0, 
A.Version0, A.Publisher0
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 '%Office%'
and A.DisplayName0 NOT LIKE '%adobe%'
and A.DisplayName0 NOT LIKE '%Hotfix%'
and A.DisplayName0 NOT LIKE '%Update%'
and A.DisplayName0 NOT LIKE '%Windows%'

and CollectionID ='sms000ds'

Group By A.DisplayName0, A.InstallDate0, A.Version0, A.Publisher0, B.Name0
Order By b.name0

Let us know if it satisfies your requirement.

Have you  looked at the built-in report called Count all inventoried products and versions? This will give you most of what you want.

Hi Rajeesh... FYI only, your query will only find x86 software. You should use dbo.v_Add_Remove_Programs to find both x86 and x64.

Thanks for the update Garth. I'll note that.