Report or Query for x86 Office Installs

[CraigSCCM]

Hi guys, I need to find all workstations in our Organization that have Office 32bit installed

 

All of our Clients have x64 OS and x64 Office, but some (before i started the company) have 32bit Office installed

 

I have searched the web, and found a couple of queries but they didn't pull any information down

 

Any help would be greatly appreciated

 

Thanks

[simulacra75]

One option (but you will need to read info from the registry first) is to check the value of the registry key called "Bitness" under HKLM\Software\Microsoft\Office\14.0\Outlook

 

This will have a value of either x86 or x64 (indicating the version of Office that is installed on a machine).

 

Hope this helps

[CraigSCCM]

Hi simulacra75, thank you for the reply, i have seen that before, but i'm not sure how to intergrate it into a query or report?

[simulacra75]

Well you first need to gather the actual information, it's not collected by the CM12 inventory process by default. Check this http://it.peikkoluola.net/2013/06/20/extend-sccm-client-hardware-inventory-with-a-custom-attribute-value/ for more information.

[Garrett804]

Another query you can run it against is the Product ID as it will be different for the 32-bit than it is for the 64-bit version.

[regan]

I do this for my updates, hope it helps x86

 

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

 

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 = "Microsoft Office Professional Plus 2010"

[CraigSCCM]

I do this for my updates, hope it helps x86

 

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

 

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 = "Microsoft Office Professional Plus 2010"

 

Hi mate, thank you very much for this, i slightly modified yours and i got the results i need, here is mine

 

 

 

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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID 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 2010%") and SMS_G_System_COMPUTER_SYSTEM.SystemType = "X86-based PC"

[GarthMJ]

Keep in mind that your will NOT find any x64 computers with x86 version of Office.

[CraigSCCM]

Keep in mind that your will NOT find any x64 computers with x86 version of Office.

 

Hi GarathMJ, how come this won't pull the relevant information down?

 

Have i missed something on the query?

 

Thanks

[GarthMJ]

If you look at your query you are explicitly saying that you only want to look at x86 computer and don't want to see any data from x64.

 

"SMS_G_System_COMPUTER_SYSTEM.SystemType = "X86-based PC""

 

This will filter out any x64 computer with an x86 version of Office.