question

5Y54DMIN-6383 avatar image
0 Votes"
5Y54DMIN-6383 asked ·

Create collection based on 32bit application, on 64 bit windows

I have machines running windows 64bit OS. Some machines have 64bit office other have 32bit office 2019.

Trying to create two collections one that has the 64 bit office, with the other 32 bit office.

I have the below for the 32 bit version, however nothing is added to the collection. I think its because we have no 32bit operating systems. but i thought the two attribute classes installed Applications and installed applications 64bit, looked at the bit type for the app and not the OS.

installed applications
(Returns no Devices)

 select distinct 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 like "Microsoft Office Professional Plus 2019%"

How when i look for installed applications 64 bit i get devices:
(This one does return devices.)

 select distinct 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 Plus 2019%"

Any idea what I'm missing here?





mem-cm-generalmsc-essentials-general
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GaryBlok avatar image
0 Votes"
GaryBlok answered ·

Are you able to leverage the Office inventory data? If so, that might make life easier.
56484-image.png

56485-image.png



image.png (279.9 KiB)
image.png (64.2 KiB)
· 6 · Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

II did find that last night, however how do i know its tied to office 2019 and not 2016?

we still have machine that have office 2016 32 bit. And we have machines that have office 2019 32 and 64.

0 Votes 0 ·
GarthJones-MVP avatar image GarthJones-MVP 5Y54DMIN-6383 ·

You challenge that you are going to get is that Office 32 bit will write to the 64 bit key for ARP. As such you will have to get creative with your collections. And you might need to look at using include and exclude collections.

0 Votes 0 ·
5Y54DMIN-6383 avatar image 5Y54DMIN-6383 GarthJones-MVP ·

yea that is what I'm seeing that the 32bit office 2019 writing to 64 bit add and remove programs......

0 Votes 0 ·
5Y54DMIN-6383 avatar image 5Y54DMIN-6383 GarthJones-MVP ·

Also even if i do the below.

 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_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FilePath = "C:\\Program Files (x86)\\Microsoft Office\\Office16\\" and SMS_G_System_SoftwareFile.FileName = "WINWORD.EXE"

IT will still shows up with machines that have office 2019 in the collection, because the path still exists, and WinWord.exe is one the machine just not in that directory. Is there a way to change the query for if WINWORD.EXE is in that directory, and not just existing on the machine?


0 Votes 0 ·
Show more comments
FionaYan-MSFT avatar image
0 Votes"
FionaYan-MSFT answered ·

@5Y54DMIN-6383

Thank you for posting in Microsoft Q&A forum.

As agreed with Gary, this wql query may also help you to find the x32 and x64 version of the office:
wql-query-for-both-x86-and-x64-version-of-software

Have a good day!


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.