SOLVED WQL Report for Microsoft Office all Version

[tata789]

hello
I am trying to WQL query for get all Microsoft Office type and all version and NetBIOS name I able to do 32 and 65 BIT version but not able to get all microsfot version list if anyone can help that will be great I need soon and this is the WQL script I am using

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_64 on
SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version, SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Microsoft % Standard%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Microsoft % Professional%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Microsoft % Enterprise%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Microsoft % 365%"

just need help to add version please help?

thank you
Arun

 

[Garth]

This blog will help you. https://www.enhansoft.com/blog/does-your-os-architecture-x86-or-x64-matter-within-a-query

 

[tata789]

hello
Thank you for your help but I am getting this report only thing I am not getting Version number and I did post my WQL Query I try to get Version Number but not able to do it that is why I post
thank you
Arun

 

[Garth]

Why can't you add version numbers? What error are you getting?

 

[tata789]

I try to add version number but were and what is the parameter
I try to add this
SMS_G_System_ADD_REMOVE_PROGRAMS.Version, but did not work
thank you

 

[Garth]

You have to give me more details, if you want help. What didn't it work? How are you trying to add the version number? Why are you adding that version when you are looking at x64 ARP titles in your query, aka why not use the x64 version number?

 

[tata789]

if I run 32 bit

with this WQL Query I get report and this is query I am running
select SMS_R_System.NetbiosName, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version, SMS_G_System_ADD_REMOVE_PROGRAMS.ProdID 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 ProPlus - en-us%"

report

L-324988 Microsoft Office 365 ProPlus - en-us 15.0.4841.1002 O365ProPlusRetail - en-us
L-346060 Microsoft Office 365 ProPlus - en-us 15.0.4711.1003 O365ProPlusRetail - en-us
L-346073 Microsoft Office 365 ProPlus - en-us 15.0.4711.1003 O365ProPlusRetail - en-us
L-346413 Microsoft Office 365 ProPlus - en-us 15.0.4711.1003 O365ProPlusRetail - en-us

when I run 64 bit wql 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_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Microsoft % Standard%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Microsoft % Professional%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Microsoft % Enterprise%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Microsoft % 365%"

report
16777221 System W-605719 GUID:434aa3fe-c89b-4b32-b024-c88d9eb3cb93 WMATA Yes
16777220 System CTDCISCCMW7DV GUID:EFD915C9-AEAD-40EB-A546-AE3A8D7935A9 WMATA Yes
16777263 System W-606976 GUID:c0532d6e-f154-4e24-9575-b87e2556f199 WMATA Yes
16777263 System W-606976 GUID:c0532d6e-f154-4e24-9575-b87e2556f199 WMATA Yes
I am not getting version number like this

15.0.4711.1003
thank you

 

[Garth]

Your query are displaying different columns, notice you don't have any of the ARP columns in the second query. Match up the column and everything will be fine.

But why do this at all in Queries like this. Why not use the built-in reports for this? What exactly are you going to do with this query?

Again I will ask How are you creating these queries? Are you cutting and pasting these queries from somewhere or are you building them yourself?

 

[tata789]

hello
I am trying everything I search on google and find some example and also I am doing my own and I am not best in query that is why I ask help
I like to thank you for helping me
thank you
Arun