SOLVED SCCM – Report all software in Add and Remove Programs

[Michael Ballack]

This is using SCCM 2012 r2. I am a newbie to the reports. I want to create a report to show all the computer's program in add/remove programs for a collection of computers. How to create it, step-by-step or showing the SQL statement?

Thanks

 

[Prajwal Desai]

Try this and let me know if this worked for you.

Select DISTINCT SYS.Netbios_Name0,SYS.Resource_Domain_OR_Workgr0,SP.CompanyName, SP.ProductName, SP.ProductVersion

FROM v_GS_SoftwareProduct SP

JOIN v_R_System SYS ON SP.ResourceID=SYS.ResourceID

JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID

WHERE fcm.CollectionID = ‘<CollectionID>’

ORDER By SYS.Netbios_Name0, SP.CompanyName, SP.ProductName, SP.ProductVersion

replace <CollectionID> with your actual collection name before you execute the query.

 

[Prajwal Desai]

@Michael Ballack - Any update on this ?.

 

[Michael Ballack]

Thanks Prajwal, this is the report I want. thanks.

 

[Prajwal Desai]

Thank you for the update. Marking this thread as Solved.