sccm collection for add and remove programs with ms office

In my last post http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/ showed how to create sccm report to list computers with different versions of application installed on computers. This is to list the computers in collection rather report.

Create a collection and edit the query ,paste the following into it.

select *  from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Office1%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Office2%"

Please replace the bold letters with the correct application name displayed from add and remove programs.