Office 365 query

[vanderaatje]

Hi,

 

I'm trying to create a Device Collection by using the following query:

 

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 365 ProPlus - nl-nl"

 

But it doesn't seem to work

I also tried "Microsoft Office 365 ProPlus" also with no positive result

 

Hope someone can help me

 

[GarthMJ]

Keep in mind that query will only find x86 version of Office 365. You need to add the x64 class too if you want both x86 and x64.