SOLVED Device collection query rule for office 2016

[VentAcruZ]

Hi,

We have in out environment an existing device collection that has a query rule that queries for all office 2013 devices.

but now we are in progress of deploying Office 2016 and I want to make a device collection that has query rule for Office 2016.

Right now we have a few stations that has the Office 2016 installed so i created the collection and that added a query rule:

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 2016"


That is the exact rule that the office 2013 collection has just in the end it has the 2013 and not the 2016...
For some reason it can't find me any devices


What can I do?


Thank you

 

[Prajwal Desai]

The query many not work for office 2016. May i know is it 32-bit or 64-Bit office that is deployed ?. If it's 64 bit use SMS_G_System_ADD_REMOVE_PROGRAMS_64 in query.

 

[VentAcruZ]

I got to manage it in the.
I used a criteria with installed software with APR Display name.

Thank you