Computers with Office 2010 is installed

[CoNtAcT2000 0]

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 )

[Jorgen Nilsson 44]

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

[JDM1021 0]

Can someone write out the whole query that needs to be entered? I need to isolate just machine with Office 2010 x64 installed.

[regan 1]

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