sccm collection for add and remove programs with ms office

In my last post 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.

Leave a Reply