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:
Please log in to answer
Posted by:
rileyz
8 years ago
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
8 years ago
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.
" 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 8 years ago
