PENDING Creating collections Office 32 bit and 64 bit

[dj3094]

Hello all,

I am trying to create collections for machines with office x64 and x86 installed. for x64 i got below query but it is getting x86 as well
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 "Microsoft Office Professional%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "Microsoft Office 365%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "'Microsoft Office Enterprise %"

any suggestions?

Regards

 

[Garth]

You can get the x32 from the SMS_G_System_ADD_REMOVE_PROGRAMS view.
don't forget that you can have two queries for a collection membership.

Combining Two WQL Queries in One Collection

In a recent forum post someone asked for help with combining two WQL queries (see below WQL Query 1 and WQL Query 2) into one query. It is possible to

www.enhansoft.com

 

[dj3094]

Thanks Garath,

The query I posted is give me x86 as well, what can i change in there to get only x64?

Regards

 

[Garth]

Thanks Garath,

The query I posted is give me x86 as well, what can i change in there to get only x64?

Regards

The query listed above grabs the data from the x64 ARP data. and Not from the 32 bit ARP. There is no way to determine the different data based on that only comes from x64 ARP.

 

[dj3094]

I have 32-bit on mine but it picked up my machine somehow.
any thoughts?