SOLVED WQL Query Windows 10 OS with what version Microsoft Office Installed

[tata789]

hello
I need bit help, I need report list for Windows 10 OS and what version of Microsoft Office Installed
If some one know WQL Query to get that kind of report that will be good
I only can run WQL Query, can not run SQL because SQL team did not give me any access to run SQL Query

thank you
AK

 

[Garth]

What do you have for a query now and what isn't working with it?

 

[tata789]

hello
I have two diriment WQL query one for win 10 and one for Office 2013, and I am not very good in Query, that is why I ask for help

Win 10 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 where SMS_R_System.OperatingSystemNameandVersion like "%Microsoft Windows NT Workstation 10%"

Office 2013 WQL Query

select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version 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" order by SMS_R_System.Name

and I like to run as one and list computer name and OS win 10 and office 2013

thank you

 

[Garth]

So you add the add remove program view in just like you did in the second query. that will give you want you want.

 

[tata789]

Sorry I try and i was not able to work, that is why i post , please if you can help that will be good.
I am not good in query, it is my worst part
Thank you
AK

 

[Garth]

Sorry I try and i was not able to work, that is why i post , please if you can help that will be good.
I am not good in query, it is my worst part
Thank you
AK

So how exactly did you create the queries above? Or did you cut and paste these from somewhere else?

 

[tata789]

No, I have the wql query I am using for while and I keep data just you never know when I will need

 

[Garth]

No, I have the wql query I am using for while and I keep data just you never know when I will need

Take the first query and paste it into query.
Then using the wizard edit the query and add Software inventory class with the right SW name.

 

[tata789]

hello
i created as you said and look 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_R_System.OperatingSystemNameandVersion like "%Microsoft Windows NT Workstation 10%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Office Professional Plus 2013"

only report showed 137 count i thing it should be more
please take a look, if any thing i missed.
if you know better way to do please share
i like to thank you for your help

thank you
AK

 

[Garth]

it looks fine why do you think there should be more?

 

[tata789]

hello
just i thought should be more higher number than 137,
may be i mad some error but you looked at it and look good , i am fine with that
thank you for your help
can mark as solved
thank you
AK