PENDING SCCM Query for Office 365 Install x32/x64

[harveybham]

Hi,
Does anybody have a working query for SCCM that i can use to detect x32 version of office click to run and x64 version of office click to run?

Thanks

 

[Garth]

Have you looked at the built-in reports for this?

 

[harveybham]

Hi Garth

I did take a look at this but i could not find it

 

[Edy]

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_OFFICE365PROPLUSCONFIGURATIONS on SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.Platform = "x86"

and for 64 bit just change x86 to x64

 

[harveybham]

Thanks Edy Thats workted a treat