hi, how to create collection ms office 2 or more version installed in single system kindly help.Kiran

create a collection with below query : SELECT c.Name0, a.DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS a, v_R_System c WHERE a.ResourceID = c.ResourceID AND( a.DisplayName0 like '%Ms office%' OR a.DisplayName0 like '%Office%') GROUP BY c.Name0, a.DisplayName0 ORDER BY c.name0 Please replace the the bold letters with required application name from add and remove programs. More Via http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/ //Eswar Koneti @ www.eskonr.com

You can use Eswar's query, but I have only one version of Office installed on my system (Office 2010) but we use Office Communicator 2007 here, so I would my system would display using that query. Alternatively, you can create one Collection of the first version of Office (Office 2007) and create another Collection for systems with the second version of Office (Office 2010) then create a Collection using two subselect queries IS IN Collection1 OR IS IN Collection 2. That way you would already have them separated by version anyway...--Joe.

Hi Eswar, I need create Dynamic Collection kindly help. Kiran

I think, the above one is dynamic collection query?Anoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.

I think, the above one is dynamic collection query? No, the above one is SQL query, which cannot be used for creating collections. He'd need a WQL one. This thread contains examples: http://social.technet.microsoft.com/Forums/en-US/configmgrswdist/thread/78bd3276-6ac6-4cc9-bd7c-584f95bc7ea1Torsten Meringer | http://www.mssccmfaq.de

Ooops.I didn't notice that ..Anoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.

Ohh. Yeah that is SQL query used in reports. Here is WQL query that should give you the computers with office installed . 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%" Replace the Bold letters with correct application name from ARP via http://eskonr.com/2010/02/sccm-collection-for-add-and-remove-programs-with-ms-office/ //Eswar Koneti @ www.eskonr.com

Hi, this above Query showing any one office i need two versions in the same pc . i try to add 'and' but nothing found kindly helpKiran

Kiran Which two versions are you looking for? As I said in my earlier post, create a Collection of the first version, and a Collection of the second version. Then create a collection using a subselect value...the only correction to my previous post is that you should use AND between the subselects..once you have the Collection query correct (and this will be dynamic), delete the other two Collections if you choose. I would keep them though as its a way to keep track pf which version is installed on each system since the Collection itself will not list the version installed.--Joe.

Hi, this above Query showing any one office i need two versions in the same pc . i try to add 'and' but nothing found kindly help Kiran can you post the query which you tried that list none results also the two versions office names(from ARP)? //Eswar Koneti @ www.eskonr.com

This should work...it uses two subselects and assumes you are looking for Office 2007 and office 2010. You'll need to change the query acordingly... select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.NetbiosName in (select SMS_R_System.NetbiosName 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 = "Microsoft Office Professional Plus 2007") and SMS_R_System.NetbiosName in (select distinct SMS_R_System.NetbiosName 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 = "Microsoft Office Professional Plus 2010") --Joe.