CoNtAcT2000 0 Report post Posted June 28, 2011 Hi, i want to build a dynamic collection to deploy our software on a fresh installed client. Ive created a TS to deploy Windows 7 (PXE boot) and joining our domain. Works fine until here. After joining the domain the pc should get all our standard software - like Office 2010, 7zip...... as fast as possible. Ive created a new collection with the following query: 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.ResourceID not in (select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Office Professional Plus 2010") The Testsystem shows up. And Office 2010 Installation starts after a few minutes. But after the sucessfully Installation the Testsystems dont disappear from the collection. (ive startet a manual hardware inventory after the office installation - after that i can see the Microsoft Office Professional Plus 2010 entry under Software(64)in the Resource Explorer) Whats wrong? Is it because of 64 bit Office? Thanks for help (and sorry for the bad english ) Share this post Link to post Share on other sites
Jorgen Nilsson 44 Report post Posted June 28, 2011 Hi, yes, you need to add a query which queries SMS_G_System_ADD_REMOVE_PROGRAMS_64 for installed 64-bit applications for 64-bit applications. Regards, jörgen Share this post Link to post Share on other sites
JDM1021 0 Report post Posted July 29, 2014 Can someone write out the whole query that needs to be entered? I need to isolate just machine with Office 2010 x64 installed. Share this post Link to post Share on other sites
regan 1 Report post Posted October 16, 2014 i use this but obviously your need to change it for _64 to get X64 applications and then the version of office you running 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 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" order by SMS_R_System.Name Share this post Link to post Share on other sites