Hello all,
I'm trying to gather a report of all Software in Add or Remove Programs from SCCM. I need to identify which servers or workstations have the software installed. I understand this is going to generate numerous rows per computer, but this is what has been asked by management. Note, we are closer to purchasing 3rd party software to assist with the normalization of this data. But, for now, I have to work with what I have. Here is the baseline query I am using: Declare @CollID char(8) Set @CollID = 'SMS00001' SELECT DisplayName0, Count(*) AS 'Count', Publisher0, Version0, @CollID as CollectionID FROM v_Add_Remove_Programs arp JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID WHERE fcm.CollectionID = @CollID GROUP BY DisplayName0, Publisher0, Version0 ORDER BY Publisher0, Version0 Can someone please tell me how I can modify the above query to include the servers or workstations that have the software installed? Thanks, Brian
