/build/static/layout/Breadcrumb_cap_w.png

SCCM 2012 noob. Need help with queries. Trying to find the software versions that are out in the wild for Office 365

Just started with SCCM and am slowly getting my feet wet.  I have been tasked with creating a simple query but I'm finding it's not so simple. 

We are running Office 365 ProPlus and I have been tasked with creating a query that will tell me what version of the product is running on every machine.  We are checking to see how many computers are updated to the newest version.

I tried this but it says it has syntax errors.  I'm copying and pasting this one and I don't know where the error is as I have no idea what the proper structure would be.  Can anyone educate me in how to do this?  

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%”

0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: rileyz 7 years ago
Red Belt
0
There will be a 'canned' report you can use from SCCM - saves creating the query yourself. When Im at work on Monday I'll dig it out for you. The reports the SCCM provide are quite vast and to pick the right one can be a bit of a nightmare.
Posted by: rileyz 7 years ago
Red Belt
0

Top Answer

Fixed it!

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%"

Looks the same? Almost, check your quotes next time (;
" and
You need stright quotes, always check in Notepad++ or your fav notepad for the correct quotes when you copy and paste from the interwebs.


Comments:
  • Thats what I get for copypasta!!! Thanks a lot!!!! - kellanist 7 years ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ