arcarsenic Posted August 25, 2015 Report post Posted August 25, 2015 I work at a community college and we have sccm clients running Office versions from 2003-2013. I have scoured the web trying to find a query that could accomplish this task, but with my lack of SQL knowledge and specificity of the statement, I couldn't find a solution. Any thoughts? Quote Share this post Link to post Share on other sites More sharing options...
regan Posted August 25, 2015 Report post Posted August 25, 2015 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 2010" order by SMS_R_System.Name change for the office type you want and x86 or x64 version Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted August 25, 2015 Report post Posted August 25, 2015 So have you looked at the built-in reports? Why not start with them and edit them to add/remove what you need. Quote Share this post Link to post Share on other sites More sharing options...
Eswar Koneti Posted August 29, 2015 Report post Posted August 29, 2015 try this SSRS Report http://eskonr.com/2015/01/sccm-configmgr-2012-ssrs-report-count-ms-office-versions/ Quote Share this post Link to post Share on other sites More sharing options...
