Jump to content




Sign in to follow this  
CoNtAcT2000

Computers with Office 2010 is installed



Recommended Posts

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


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

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


×