give me a few minutes On Thu, Jun 9, 2016 at 1:21 PM, Brian McDonald <[email protected]> wrote:
> 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 > >
