PENDING How to collect Office by installed version using device collection

[mson]

hi! I'm writing because I have a question.
I created a Device collection query like this:
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 like "Microsoft Office 365%"
Is it true that you can collect it this way?
Additionally, I would like to know where and what information is collected.

 

[Garth]

hi! I'm writing because I have a question.
I created a Device collection query like this:
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 like "Microsoft Office 365%"
Is it true that you can collect it this way?
Additionally, I would like to know where and what information is collected.

What do you mean by collected? What are you going to do with this collection? What isn't this collection query doing for you?

 

[Prajwal Desai]

hi! I'm writing because I have a question.
I created a Device collection query like this:
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 like "Microsoft Office 365%"
Is it true that you can collect it this way?
Additionally, I would like to know where and what information is collected.

What do you intend to collect from this query?. Just the office version?

 

[mson]

What do you mean by collected? What are you going to do with this collection? What isn't this collection query doing for you?

HI. garth!
I'm trying to collect devices with Office 365 installed using this query.

 

[mson]

What do you intend to collect from this query?. Just the office version?

hi. Prajwal Desai!
I'm trying to collect devices with Office 365 installed using this query.

 

[Garth]

HI. garth!
I'm trying to collect devices with Office 365 installed using this query.

and what is not working with the query?