This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E5%3C/text%3E%3C/svg%3E)
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?
Are you able to leverage the Office inventory data? If so, that might make life easier.
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.
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.
yea that is what I'm seeing that the 32bit office 2019 writing to 64 bit add and remove programs......
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?
SW inventory is unreliable! Don't use it. https://www.enhansoft.com/sccm-software-inventory/
What is wrong with using the Office Bitness flag collected via hardware inventory?
When i build queries for the bitness not all the machines are added to the collection, that have office.
Microsoft Office Professional Plus 2019 32bit please note with this one i had to use the SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName Because i think it install no matter what to the 64bit table even though its 32 bit. I think its because the bootstrapper is 64bit while the installed program is 32bit.
Thoughts?
Had to post my query o pastbin as i exceeded 1000 chars.
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.