SOLVED Creating Office Collections for X86 & X64 Version Deployments

[Niven Nair]

Hi

We have decided to roll-out Mimecast for Outlook and are required to create two collections for machines that have X86 and X64 Versions of outlook. Our problems are there are multiple Versions of Office that run in the enviroment from office 2010 to O365 we are finding difficult to find out which machines have a X86 version of Outlook and Which have X64, We need to be able to determine this, before we can deploy the correct version of the Mimecast for Outlook package correctly.

Please assist.

Kind Regards,
Niven Nair

 

[Youssef Saad]

Hi Niven Nair,

You can create a collection computers based on query.

Office X86:

select SMS_R_System.IPAddresses, SMS_R_System.NetbiosName, SMS_R_System.ADSiteName
from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS
on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM
on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId
where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Office Professional Plus 2010%"
and SMS_G_System_SYSTEM.SystemType = "X86-based PC"

Office X64:

select SMS_R_System.IPAddresses, SMS_R_System.NetbiosName, SMS_R_System.ADSiteName 
from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64
on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "Microsoft Office Professional Plus 2010%"

NB: Just change "Microsoft Office Professional Plus 2010" to your version.

 

[Niven Nair]

Hi Niven Nair,

You can create a collection computers based on query.

Office X86:

select SMS_R_System.IPAddresses, SMS_R_System.NetbiosName, SMS_R_System.ADSiteName
from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS
on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM
on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId
where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Office Professional Plus 2010%"
and SMS_G_System_SYSTEM.SystemType = "X86-based PC"

Office X64:

select SMS_R_System.IPAddresses, SMS_R_System.NetbiosName, SMS_R_System.ADSiteName
from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64
on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "Microsoft Office Professional Plus 2010%"

NB: Just change "Microsoft Office Professional Plus 2010" to your version.

 

[Niven Nair]

Hi

Thanks for your Email.

O365 versions reporting 64BIT but actually 32BIT. Appreciate your help.
Any Ideas as to why?

 

[Youssef Saad]

There is the query for O365 X64 :

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_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Office 365%"

 

[Youssef Saad]

Any update?