SOLVED Collection Query for Office 2013 Pro Plus x64

[ikkhatri]

Hi There,

Thank you for your wonderful guides which helped me deploying Office 2013 Pro Plus.

I was looking for a collection query that will show me all computers with Office 2013 installed.

Currently I am using 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 = "Microsoft Office Professional Plus 2013"

Members visible on site = 0 (which is not true)

Would you happen to know of one that works?

Thank you.

 

[Mahmoud87]

Hi There,

Thank you for your wonderful guides which helped me deploying Office 2013 Pro Plus.

I was looking for a collection query that will show me all computers with Office 2013 installed.

Currently I am using 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 = "Microsoft Office Professional Plus 2013"

Members visible on site = 0 (which is not true)

Would you happen to know of one that works?

Thank you.

Hi mate, I am running this in my environment and it's working great. It allows you to find 2 applications based on the display name

select
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Office%2013%" and 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 '%Compatibility%Pack%')

This if you after 1 application only.

select
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Office%2013%"

 

[Prajwal Desai]

Note - If the office is 64 bit use SMS_G_System_ADD_REMOVE_PROGRAMS_64 in query.

 

[ikkhatri]

Hi mate, I am running this in my environment and it's working great. It allows you to find 2 applications based on the display name

select
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Office%2013%" and 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 '%Compatibility%Pack%')

This if you after 1 application only.

select
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Office%2013%"

My apologies for a super late response! Very much appreciate the above query provided.